Skip to content

Registered aircraft · 20,481

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.

N96734D & G Aviation LLC · Woodward, OKBuilt 1976 · S/N 21061213 N96737Smith Flying Farms LLC · Leoti, KSBuilt 1979 · S/N 18266833 N96739Euroaviation Inc Trustee · KematenBuilt 1979 · S/N 18266834 N96742Parsons Lisa A · Shade Gap, PABuilt 1979 · S/N 18266837 N96749Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18266840 N9674GN1705r Inc · Cobb, CAS/N U20601874 N9675BBlessum Jay · Minot, NDBuilt 1957 · S/N 32972 N9675XKenai Gravel Products LLC · Galena, AKFirst renewal noticeBuilt 1962 · S/N 21057975 N9676BAnselment Barney A · Polson, MTBuilt 1957 · S/N 32973 N9676XMoore Samuel B · Tucson, AZBuilt 1962 · S/N 21057976 N96783Campbell George A · Aubrey, TXBuilt 1979 · S/N 18266851 N96784Arnett William J · Heber Springs, ARBuilt 1979 · S/N 18266852 N96798Curl Kathryn Ann · Idaho Falls, IDS/N 18266856 N9679BRuehle Alex A · Denver, COBuilt 1957 · S/N 32976 N9679XMurphree David A · Lake Saint Louis, MOBuilt 1963 · S/N 21057979 N967AEKreil Curtis L · White City, ORBuilt 1962 · S/N 21057978 N967CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281967 N967DGPersinger Kenneth W · Fairbanks, AKBuilt 1956 · S/N 33567 N96804Petecraft Aviation Services Inc · Plains, GABuilt 1979 · S/N 18266857 N9681Srividya Aviators LLC · North Brunswick, NJBuilt 1998 · S/N 18280233 N96810Gordin Michael E · Lakeland, TNBuilt 1979 · S/N 18266859 N96814Airplane Leasing LLC · Jupiter, FLFirst renewal noticeBuilt 1979 · S/N 18266860 N9681FSplashdown Aviation LLC · Dunedin, FLBuilt 1998 · S/N 18280268 N9681XCentral Aviation LLC · White City, ORS/N 21057981 N96821Tdm Aviators LLC · Madison, ALBuilt 1979 · S/N 18266863 N9683TFroes Carlos D · Avondale, AZFirst renewal noticeBuilt 1960 · S/N 57483 N9683XBates Roger · Palm Beach Gardens, FLBuilt 1962 · S/N 21057983 N96840Brad Force One LLC · Terre Haute, INBuilt 1979 · S/N 18266872 N96843Southside Air LLC · Bakersfield, CABuilt 1979 · S/N 18266874 N96844Flying Truckster LLC · Denver, COBuilt 1979 · S/N 18266875 N9684TKobe Thomas J · Lake Placid, FLBuilt 1960 · S/N 57484 N96852Inland Northwest Flyers LLC · Spokane Valley, WABuilt 1979 · S/N 18266879 N9685BJones Jason B · Anchorage, AKBuilt 1957 · S/N 32982 N9685TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57485 N9686XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057966 N9687EFrohbieter Jack A · Newtown, PABuilt 1984 · S/N 18268437 N9687TPractical Software Solutions Inc · Windsor, COBuilt 1960 · S/N 57487 N96883Knash Partners Nwa LLC · Summers, ARBuilt 1979 · S/N 18266886 N96885Chord Line LLC · East Hampton, NYBuilt 1979 · S/N 18266887 N9688XDrm Aviation LLC · Glencoe, ALBuilt 1962 · S/N 21057988 N96893Neu Rick L · Kingwood, TXBuilt 1979 · S/N 18266890 N9689BCoffin Robert H · Wasilla, AKBuilt 1957 · S/N 32986 N9689TSutphen Clinton M · Saint Hedwig, TXBuilt 1960 · S/N 57489 N968CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281968 N968KOpheim Kurt · Minnetrisia, MNS/N 18051603 N96906Nulisch Justin · Del Rio, TXBuilt 1979 · S/N 18266893 N96919Mckitrick Brad L · West Jefferson, OHBuilt 1979 · S/N 18266895 N9691BRegistered aircraftBuilt 1957 · S/N 32988 N9691GFox Michael F · Hernando, FLBuilt 1974 · S/N 18263431 N9691ZSouth America Mission Inc · Fort Mill, SCBuilt 1982 · S/N U20606611

Back to AD 84-10-01 R1