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.

N2508GBig Well Flying Club Inc · Kinsley, KSBuilt 1959 · S/N 51808 N2508RBrodt Gregory L · Chetek, WIBuilt 1967 · S/N 18258208 N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311 N2508XCaspaar Valentin · Seattle, WABuilt 1965 · S/N P206-0008 N2509KHolcomb John R · Siloam Springs, ARBuilt 1978 · S/N 18052962 N250CW250 Charlie Whiskey LLC · Topeka, KSBuilt 1982 · S/N 18268273 N250ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608250 N250EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 2020 · S/N 18283106 N250FBishop Thomas W · Decatur, TXBuilt 1959 · S/N 52184 N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130 N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873 N2511RDickey Mark D · Pendleton, ORS/N 18258211 N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812 N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712 N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813 N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2517ZGerrety Loren P · Anchorage, AKBuilt 1962 · S/N 185-0517 N2518QSwaldi Thomas · Marion Heights, PABuilt 1966 · S/N 18257718 N2519RPentzien Inc · Omaha, NEBuilt 1967 · S/N 18258219 N251MECavu Aircraft Group LLC · Green Cove Springs, FLBuilt 2000 · S/N 18280740 N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139 N251ZWatkinds Steven G · Hermiston, ORBuilt 1952 · S/N 7842 N2520GGrinch Aviation LLC · Madera, CABuilt 1959 · S/N 51820 N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720 N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220 N2521GMountain Aviator LLC · Edwards, COBuilt 1959 · S/N 51821 N2522GMull Morgan · Greensburg, PAS/N 51822 N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722 N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222 N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022 N2523GDannebrog Air LLC · Grand Island, NEBuilt 1959 · S/N 51823 N2523QLusk T Quizy · Springfield, COBuilt 1966 · S/N 18257723 N2523RBergamaschi Brian A Trustee · Davis, CABuilt 1967 · S/N 18258223 N2524KGanz Brian L · Carlsbad, CABuilt 1978 · S/N 18052969 N2524QBellamy Flying LLC · Elwood, NEBuilt 1966 · S/N 18257724 N2525GWoods Dana · Mountain View, ARBuilt 1959 · S/N 51825 N2525QHohman Cory A · Lometa, TXBuilt 1966 · S/N 18257725 N2525RBrandt Jimmie L · Elbert, COBuilt 1967 · S/N 18258225 N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803 N2525ZMansfield Scott J · Wasilla, AKBuilt 1962 · S/N 185-0525 N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226 N2526XBolin David A · Kenmore, WAS/N P206-0026 N2527GRafter H Livestock · Rawlins, WYBuilt 1959 · S/N 51827 N2527QTwenty Inc · Wilmington, DES/N 18257727 N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228 N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028 N252AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281185

Back to AD 84-10-01 R1