Skip to content

Registered aircraft · 39,302

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:2000-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01') 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:2000-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01')
  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:2000-06-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01')
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.

N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697 N1040PShogren Dennis · Grand Terrace, CAS/N R18200368 N1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090 N1041Del Rio Aviation Inc · Paso Robles, CAS/N 337M0317 N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214 N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658 N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324 N10425Moskewich Raymond J · Morgan, VTS/N 15074854 N10428Stoup Kevin D · Altus, OKS/N 15074855 N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662 N10439Great Lakes Air Ventures LLC · Mason, MIBuilt 1973 · S/N 15074860 N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N10452Demott Steven J · Stanley, WIBuilt 1973 · S/N 15074864 N10454Ratliff Byron L · Paragould, ARBuilt 1973 · S/N 15074865 N10455Cowden Ryan A · Everson, WABuilt 1973 · S/N 15074866 N10459Ender Richard M · Rye, NHBuilt 1973 · S/N 15074868 N10466Richards Matthew · Southaven, MSS/N 15074870 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N10473Vincent Geoffrey M · Andover, KSBuilt 1973 · S/N 15074873 N10474Some Beech LLC · Bolivar, MOBuilt 1973 · S/N 15074874 N10478Van Winkle Nicolas A · Renton, WABuilt 1973 · S/N 15074877 N1047FBondurant Jok · Talkeetna, AKS/N 18502704 N10483Tennant Michael D · Granite Falls, WAS/N 15074881 N10487Wonderboy Aviation LLC · Hollsopple, PABuilt 1973 · S/N 15074885 N10488Heller John S Sr · Jackson, WIBuilt 1973 · S/N 15074886 N10495Pacific Electro Mechanical Inc · Pearl City, HIBuilt 1973 · S/N 15074888 N10498Scoma Steven G · Rhome, TXS/N 15074890 N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238 N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517 N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009 N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727 N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742 N104HSErdmann Hollis K · Santa Monica, CABuilt 1973 · S/N 182-61758 N104JSSmith Timothy A · Shafter, CABuilt 1977 · S/N 18265625 N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392 N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122 N104KMMorrison Mitchell A · Forest, VABuilt 1970 · S/N 15072415 N104NPDv Aviation Inc · Brainerd, MNBuilt 1975 · S/N 17265021 N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693 N104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 182-63801 N104PDBaumann James R · Muskogee, OKBuilt 1973 · S/N 17261428 N104PMPats Offroad Inc · Mitchell, SDS/N 18258085 N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098 N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907 N104SPJanaitis Aviation LLC · Middletown, DEBuilt 1973 · S/N 18261667 N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212

Back to AD 2000-06-01