Skip to content

Registered aircraft · 20,483

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4346NJohnson Fredrick S Jr · Shelbyville, KYBuilt 1947 · S/N 7063 N4346VKoberg Lance L · Dallas, GABuilt 1948 · S/N 7273 N4347VSilver Cessnas LLC · Cheyenne, WYBuilt 1948 · S/N 7256 N434CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282192 N434CSBaldwin Scott Ryan · Kamas, UTBuilt 2016 · S/N 18282433 N4350VAeroclassics LLC · Waynesboro, VABuilt 1948 · S/N 7259 N4351VVandevort Lynn A · Manitowoc, WIBuilt 1948 · S/N 7260 N4352NJantzen Ronald L Trustee · Porter, OKBuilt 1947 · S/N 7055 N4352VRobertson Jon P · Acworth, GAS/N 7261 N4353NEnea Donald J · Thompson, OHBuilt 1947 · S/N 7054 N4357NDavis Charles H Jr · Manchester, MIS/N 7058 N4357VRodriguez Daniel Lee · West Linn, ORBuilt 1948 · S/N 7266 N4358VBloch Christopher P · Grand Rapids, MIS/N 7274 N435TAPanther Med LLC · Derby, KSBuilt 2001 · S/N 18281035 N4366VKopf Edward H Jr · Las Vegas, NVBuilt 1948 · S/N 7281 N4367NMajerle Joseph III · Anchorage, AKBuilt 1947 · S/N 7039 N4367VGreulich Kenneth R Trustee · Sand Springs, OKBuilt 1948 · S/N 7282 N436CSBulovic Mark · Savannah, GABuilt 2016 · S/N 18282428 N437Sackett Scott H · Krum, TXBuilt 1952 · S/N 7930 N4371NCole David L · Granbury, TXBuilt 1947 · S/N 7035 N4373NApple Jeffrey G · Sheridan, INBuilt 1947 · S/N 7033 N4373RKlc Associates · Unionville, CTBuilt 1978 · S/N R18200595 N4374VBrown Robert A · Peachtree City, GABuilt 1949 · S/N 7289 N4375VPeck Nathan Mark · Leavenworth, KSBuilt 1949 · S/N 7320 N4380NWarwick Dakota R · Jupiter, FLS/N 7026 N4383VPorter Charles R · Ocala, FLBuilt 1949 · S/N 7305 N4384KLewis Flying Service Inc · Morse, LABuilt 1967 · S/N 18051827 N4384VBennett Robert M · Felton, DEBuilt 1949 · S/N 7306 N4385NVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 7019 N4386VAlerion Aviation LLC · Elbert, COBuilt 1949 · S/N 7308 N4388VPhilbrick Rodney C · Bishop, CABuilt 1949 · S/N 7310 N438CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283345 N438SATwopro Energy Services LLC · Odessa, TXBuilt 2016 · S/N 18282421 N4391NRoy Rodney E · Grand Marais, MNBuilt 1947 · S/N 7030 N4392VKeith Harry E III · Coffeyville, KSFirst renewal noticeBuilt 1949 · S/N 7343 N4394NEnnis Shannon E · Chesapeake, VABuilt 1947 · S/N 7011 N4395VAbel John R · Haslet, TXBuilt 1949 · S/N 7323 N4398NHammerle Tye F · Kenosha, WIBuilt 1947 · S/N 7007 N439CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282355 N439CSMarionneaux Law Firm LLC · Baton Rouge, LABuilt 2016 · S/N 18282429 N439DCLaguna Sky LLC · Wilmington, DES/N 21062636 N439ESH R Management LLC · Bay Saint Louis, MSBuilt 1998 · S/N 18280130 N43AKEarth Center Adventures Inc · Haines, AKBuilt 1980 · S/N U20605545 N43DEReynolds Carl R · Bryn Mawr, PABuilt 1977 · S/N 18266212 N43HLKimbrell Heath G · Quinlan, TXBuilt 1957 · S/N 34652 N43JKEvans James · Millbrae, CABuilt 1973 · S/N 18262576 N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563 N43LSLima Sierra Inc · Nappanee, INS/N 21062124 N43LWRotgers Benjamin Leroy · Malabar, FLS/N 52159 N43SLSudtell Chad S · Wasilla, AKBuilt 1954 · S/N 31611

Back to AD 84-10-01 R1