Skip to content

Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N345YParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020123 N346Mclendon Kennon A · Fortson, GABuilt 1987 · S/N 10056C N34602Hopkins Peter Matthew · Vancouver, WABuilt 1973 · S/N 17701894 N34604Mccosh John · Piedmont, OKBuilt 1973 · S/N 17701896 N34606Coulter Lance A · Meeker, COBuilt 1973 · S/N 17701898 N3460RHenninger Mark E · Mill Creek, WABuilt 1969 · S/N 28-5687 N3460TBrowning Sean · Anchorage, AKBuilt 1968 · S/N 17700760 N3460WCarruth John T · Danvers, MNBuilt 1966 · S/N 32-331 N3460XKallner Carl Magnus · Jackson, NJBuilt 1966 · S/N 1142 N3461Vizachero Albert · Spring Lake, NCBuilt 2000 · S/N 1 N34612Hummel Frank E · Everett, WABuilt 1973 · S/N 17701901 N34614Samreth Sokham · Lorton, VAS/N 17701903 N34616Gois Paul · Westfield, MABuilt 1973 · S/N 17701904 N3461NBrown Hugh · Lubbock, TXBuilt 1967 · S/N 680060 N3461WBplj LLC · Old Monroe, MOBuilt 1972 · S/N 17261257 N3461XPerez Carlos D · Horizon City, TXBuilt 1966 · S/N 3413 N34620Patton Gilbert L · Merritt Island, FLBuilt 1973 · S/N 17701905 N3462309y Flying Club · South Saint Paul, MNBuilt 1973 · S/N 17701906 N34626Ross Amy · Los Alamos, NMBuilt 1973 · S/N 17701907 N34629Gradus Magnam LLC · Ocracoke, NCBuilt 1973 · S/N 17701910 N3462ENc86 Flying Club Inc · Mooresville, NCBuilt 1978 · S/N 17271555 N3462RFor Skies Flying Club Ltd · Martinsville, ILBuilt 1969 · S/N 28-5690 N3462TJunck Kyle D · Branson, MOBuilt 1968 · S/N 17700762 N3462XNewberry Alfred L · Harrison, ARBuilt 1966 · S/N 3414 N3462ZWilson Anthony J · Bartlett, TNBuilt 1960 · S/N 22-7384 N34631Norton David Thompson · Dallas, TXBuilt 1973 · S/N 17701911 N34634Patterson Kathleen M · Marlborough, MABuilt 1973 · S/N 17701914 N34636Ubi Aviation LLC · Palm Harbor, FLBuilt 1973 · S/N 17701915 N3463NN83993 LLC · Cherry Hill, NJFirst renewal noticeBuilt 1967 · S/N 680061 N3463ZJordan Dalton · Pataskala, OHBuilt 1960 · S/N 22-7385 N34644Juliette Aviation LLC · Allen, TXBuilt 1973 · S/N 17701919 N3464KAviation Explorers Post 8000 Inc · Ottawa, KSBuilt 1967 · S/N 28-23567 N3464XMonroy Jonathon M · Olathe, KSBuilt 1966 · S/N 1144 N34655Nick The Marketer LLC · Hoover, ALBuilt 1973 · S/N 17701925 N3465KNiepert William · Jacksonville, NCS/N 28-23568 N3465RSchissel Todd E · Decorah, IABuilt 1969 · S/N 28-5693 N3465TRutherford Keith Allen · El Paso, TXBuilt 1968 · S/N 17700765 N3465XKmlb Aviation LLC · Melbourne, FLBuilt 1966 · S/N 1145 N3465ZLutter Trent L · Hoven, SDBuilt 1960 · S/N 22-7387 N34661Fisher Ron L · Norton, KSBuilt 1973 · S/N 17701926 N34666Middleton Erik George · Vernal, UTBuilt 1973 · S/N 17701929 N3466KRegistration Pending · Bulverde, TXRegistration pendingBuilt 1967 · S/N 28-23569 N3466PKitfox LLC · Minden, LABuilt 2023 · S/N 0200022 N3466XHenley Brad L · Fairview, TXBuilt 1966 · S/N 3415 N34671Strickland Richard E Jr · Gulf Shores, ALBuilt 1973 · S/N 17701932 N34675Anderson Glenn Hunt Jr · Alabaster, ALBuilt 1973 · S/N 17701935 N34679Flanders John H · Medina, OHBuilt 1973 · S/N 17701936 N3467WRobinhood Aero LLC · Southaven, MSS/N 32-340 N3467XKnowles Christopher Alan · Oklahoma City, OKBuilt 1966 · S/N 3416 N3467Z67 Zulu LLC · Cherry Hill, NJBuilt 1960 · S/N 22-7391

Back to AD 87-10-06 R1