Skip to content

Registered aircraft · 4,242

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:89-24-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:89-24-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:89-24-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:89-24-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:89-24-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:89-24-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.

N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375 N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941 N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073 N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698 N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316 N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724 N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699 N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951 N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954 N6184CRegistered aircraftBuilt 1979 · S/N 21063824 N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701 N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287 N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620 N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653 N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963 N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377 N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329 N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043 N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705 N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967 N61BQEle Motorsports LLC · Dover, DEBuilt 1986 · S/N 21064987 N61BSKris & B Holdings LLC · Hyrum, UTBuilt 1993 · S/N EA-544 N61BWWelch William Ben · Danville, ILBuilt 2000 · S/N LIV-413 N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203 N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706 N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830 N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151 N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708 N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299 N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424 N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069 N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426 N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712 N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431 N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838 N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195 N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303 N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393 N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304 N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718 N6240VRegistered aircraftBuilt 1967 · S/N D-8628 N6240XCoal Black Cattle Co LLC · Roundup, MTBuilt 1977 · S/N 340A0437 N6246BR L Equipment And Services LLC · Monument, COBuilt 1978 · S/N 21062721 N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876 N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449 N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508 N6262KBrz Air LLC · Beaumont, TXBuilt 1979 · S/N P21000395 N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313

Back to AD 89-24-01 R1