Registered aircraft · 47,142

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N111PFFinefield James P · Cary, ILBuilt 1971 · S/N D-9300 N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111PQTriple Nickel Inc · Muleshoe, TXBuilt 1972 · S/N TC1427 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111RMBarrix Investments LLC · Weatherford, TXS/N CE-752 N111RRCook David C · Orlando, FLBuilt 1973 · S/N 18261539 N111RTJcec LLC · Washington Tr, UTBuilt 2001 · S/N 1156 N111RVRawson Keith L · Red Oak, TXBuilt 1966 · S/N TE-292 N111RXThompson William · Tampa, FLS/N 347770134 N111SHRobinson Doyle K · Panhandle, TXBuilt 1976 · S/N 21061270 N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333 N111SRPayne John A · Bloomington, ILBuilt 1981 · S/N 18268005 N111TMIreland David A · Eatonville, WABuilt 1976 · S/N D-9974 N111TTLand Of Lincoln Aviators LLC · Chicago, ILBuilt 2004 · S/N 0830 N111TWScott Hersmon Builder Inc · Ada, MIBuilt 1967 · S/N D-8641 N111TXVirginia Air LLC · Wilmington, NCBuilt 1962 · S/N TC-283 N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005 N111VMSkyline Aeronautical Services LLC · Dorado, PRBuilt 1977 · S/N TC-2081 N111VNDs Flight Services LLC · Battle Ground, WABuilt 1962 · S/N G-815 N111VSSite Development Inc · Mount Laurel, NJBuilt 1995 · S/N 29-0048 N111WDSmith Toby D · Cresson, TXBuilt 1978 · S/N TC-2126 N111WFArnold Frank W · Senoia, GABuilt 1954 · S/N 31243 N111WLCj Aero LLC · Fort Valley, VABuilt 1973 · S/N 18052407 N111WSM20r LLC · Centennial, COBuilt 2003 · S/N 29-0290 N111WWMcentire Bobby Kent · Cedar Park, TXBuilt 1981 · S/N E-1810 N111XBoone Aviation Ltd · Denver, COBuilt 1965 · S/N 310J0108 N111XXBay Area Flying Service LLC · Burlingame, CABuilt 1983 · S/N TH-1389 N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962 N111YGBrown Norris · Veradale, WABuilt 2016 · S/N T24002115 N111ZWBarker David W · Birmingham, ALBuilt 1973 · S/N E-396 N1120CBuckley Dennis P · Pawleys Island, SCBuilt 2001 · S/N E-3388 N1120MRichter Keith B · Oro Valley, AZBuilt 1972 · S/N D-9346 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130 N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121 N1121TWaddell Richard K Jr · Loveland, COBuilt 1967 · S/N 18258703 N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037 N11222Aircraft Partner Holdings Inc Trustee · BerlinBuilt 1986 · S/N 468608033 N1122BBonanza 1122b LLC · Lake Havasu City, AZBuilt 1979 · S/N EA-2 N1122PTroccoli Peter Trustee · Paradise Valley, AZBuilt 1978 · S/N D-10120 N1122YD&P Beech Aviation LLC · Concord, CABuilt 1982 · S/N EA-333 N1122ZK A Lafferty Inc · Cape May, NJBuilt 1996 · S/N E-3022 N1123MGrey Robert J · La Madera, NMBuilt 1975 · S/N 18264227 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N1123VLizarraga Tony Claude · Truckee, CABuilt 1997 · S/N E-3080 N1123XBeacon International Inc · Dover, DES/N 1214 N1124AWillhope Aviation LLC · Mckinney, TXBuilt 1969 · S/N E-157 N1124BAlaska Homestead Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34259 N1124LAkb Aviation LLC · Las Vegas, NVBuilt 2014 · S/N 0711 N1127JG36 Holdings LLC · Sioux Falls, SDBuilt 1996 · S/N E-3027

Back to AD 2000-23-21