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.

N42006Thompson Jeffrey L · Scandia, KSBuilt 1968 · S/N 18258804 N42016Roush Everett Wayne · Forsyth, GAS/N 18258810 N42020Brewster Matthew L · Chico, CABuilt 1968 · S/N 18258812 N42025Stokes Clive V · Gilbert, AZBuilt 1972 · S/N 18052301 N42026Bains Jordan John W · Anchorage, AKBuilt 1972 · S/N 18052302 N42027Dehart Dee Y · Payson, UTBuilt 1968 · S/N 18258818 N42036Murphy Steven R · Aguila, AZBuilt 1968 · S/N 18258822 N42041Armenia John Robert · Land O Lakes, FLBuilt 1968 · S/N 18258825 N42042N1622f LLC · Grand Prairie, TXS/N 18258826 N42044Van Beusekom Brian T · Loretto, MNBuilt 1968 · S/N 18258828 N42045Jones Daryn W Trustee · Sumpter, ORBuilt 1968 · S/N 18258829 N42049King Ronald E · Englewood, FLBuilt 1968 · S/N 18258830 N42051Flying M Aviation Inc · Irondale, ALBuilt 1972 · S/N 18052305 N42053Jewett Clinton Baxter Trustee · Colusa, CABuilt 1968 · S/N 18258832 N42055Klp Aeromotive LLC · Morriston, FLBuilt 1973 · S/N 18052306 N42058State Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280441 N42060Satathite Will J · Soldotna, AKBuilt 1968 · S/N 18258835 N42063Bailey Danny R · China Grove, NCBuilt 1968 · S/N 18258838 N42064Howell Jerry L · Searcy, ARBuilt 1968 · S/N 18258839 N42067S & M Aviation LLC · Exton, PABuilt 1968 · S/N 18258841 N42069Endres Merrick A · Riverview, FLBuilt 1968 · S/N 18258843 N42072Rempe Richard Henry · Bumpass, VABuilt 1968 · S/N 18258844 N42078Hellebuyck Ralph Charles Jr · Attica, MIBuilt 1968 · S/N 18258845 N42082Fmp Energy Inc · Bryan, TXBuilt 1968 · S/N 18258847 N42084Acp Aviation LLC · Oakdale, LAS/N 18052309 N42094Mdn LLC · Park City, MTBuilt 1973 · S/N 18052311 N420CSSugar Lips Aviation LLC · Kalispell, MTBuilt 2005 · S/N 18281650 N420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281494 N420HPBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 18281637 N420PKSmoking Joes Terps Co · Wasilla, AKS/N U2060868 N420SBWayne Daryl Hall II · Wasilla, AKS/N 18052313 N420WABlue Yonder Enterprises LLC · Los Altos, CABuilt 2017 · S/N 18283027 N420ZSmoking Joe'S Terps Co · Wasilla, AKS/N 30665 N42100Chamberlain Scott Alan · Payson, AZBuilt 1973 · S/N 18052314 N42105H & J LLC · Naturl Br Sta, VABuilt 1968 · S/N 18258854 N42120Spiegel Darren J · Chicago, ILBuilt 1968 · S/N 18258861 N42123Vandeusen Leon W III · Leslie, ARBuilt 1973 · S/N 18052320 N42124Wright Stephen A · St George, UTBuilt 1968 · S/N 18258864 N4212542125 LLC · Mercer Island, WAS/N 18052321 N42131Massicott David P · Friendswood, TXBuilt 1968 · S/N 18258867 N42132Witt Lawrence · Solvang, CABuilt 1968 · S/N 18258868 N42134Wilmark Anesthesia Pllc · Corpus Christi, TXBuilt 1968 · S/N 18258870 N42141Over The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 18258871 N42148Rizzo Michael R · Yorba Linda, CABuilt 1968 · S/N 18258874 N42150Custom Air Solutions LLC · Broadway, VABuilt 1968 · S/N 18258875 N42151Foster Floyd W · Lyon, MSBuilt 1968 · S/N 18258876 N42154Datil Fly Inc · Saint Augustine, FLBuilt 1968 · S/N 18258878 N42159Cutruzzula Arthur · Pittsburgh, PABuilt 1968 · S/N 18258881 N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040

Back to AD 84-10-01 R1