Registered aircraft · 47,138

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.

N1955Stephens Robert Z · Missoula, MTBuilt 1955 · S/N 23004 N1955SNielsen Jeffrey Stephen · Ashland, ORBuilt 1995 · S/N 220 N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337 N1956DPeyton Patrick J · Manorville, NYBuilt 1956 · S/N 191-229 N1956JAdamson George R · Calhan, COBuilt 1956 · S/N 32571 N1957CJbc 514 Capital Holdings LLC · Santa Ana, CAFirst renewal noticeBuilt 2013 · S/N 0514 N1957MStewart Alexander E · Medina, WABuilt 1976 · S/N 18264502 N1957RReed Gary L · Bethel, OHS/N 34578 N1957XDrummond Michael S · Burlington, NCBuilt 1965 · S/N 18256057 N1958Stonitsch Rudy H · Crestwood, ILBuilt 1958 · S/N D-5619 N1958XOrth Matthew B · Marion, KSS/N 18256058 N1958YGarner Zachary R Trustee · Anchorage, AKBuilt 1958 · S/N 50271 N1959CTisdale Anthony · Fallon, NVBuilt 1959 · S/N 51842 N1959XLyon Mark S · Layton, UTBuilt 1958 · S/N 51683 N195CDGemini Aviation LLC · Brownsburg, INBuilt 2000 · S/N 1089 N195CSTritten Aviation LLC · Weston, WIBuilt 2023 · S/N 9464 N195FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N E-2619 N195MBRoom For More LLC · Salt Lake City, UTBuilt 2025 · S/N 11066 N195WPWhiskey Papa Aviation LLC · Atlanta, GABuilt 2025 · S/N 10407 N1960DPlane Fun Inc Tr Trustee · Snellville, GAS/N CD-118 N1960MJereb Robert M · Rohnert Park, CABuilt 1976 · S/N 18264505 N1960XPena Fermina · Brentwood, NYBuilt 1964 · S/N 18256060 N1961DMulligan Kevin S · Port Alexander, AKBuilt 1961 · S/N 1850286 N1961MSwindle Malorie J · Birmingham, ALBuilt 1976 · S/N 18264506 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1963EPrideaux Paul M · Henrico, VABuilt 2008 · S/N 3082 N1963MN1963m LLC · Torrance, CABuilt 2002 · S/N 0355 N1963PBordeaux Bo Co · Sacramento, CABuilt 1963 · S/N D-7300 N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822 N1965SN1965s LLC · Williamstown, NJBuilt 1964 · S/N D-7653 N1965TWeld Kenneth Jr DBA · Port Orange, FLBuilt 1964 · S/N D-7543 N1965ZBushwack Air Inc · Phoenix, AZBuilt 1965 · S/N D-7805 N1966MRomeo Whiskey LLC · Wilmington, NCBuilt 2021 · S/N 5142 N1967XInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 18256067 N1968AChristopher Chester F · Bay Saint Louis, MSBuilt 1973 · S/N M3370129 N1968DBellamy Inc · Three Forks, MTBuilt 1968 · S/N TE-576 N19694Farrell Timothy S · New Meadows, IDBuilt 1981 · S/N 18053179 N1969LBlue Skys Aviation LLC · Wilmington, DEBuilt 2004 · S/N L2K-181 N1969PPie In The Sky Aviation LLC · Eads, TNBuilt 2007 · S/N 2481 N1969XCrouch Jeffrey L · Rockingham, NCBuilt 1965 · S/N 18256069 N196AVWarren Mark W · Arlington, WABuilt 1958 · S/N 51326 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N196GXRhodes David · Washington, DCBuilt 2006 · S/N 29-0414 N196MAvion Consulting LLC · Wilmington, DEBuilt 1964 · S/N 285 N196MCBond Heather Temperance · Knoxville, TNBuilt 2010 · S/N 2071 N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049 N196SRWhen Elephants Fly LLC · Camden, DEBuilt 2007 · S/N 2750 N196TCClements Dylan A · Burlington, WIBuilt 1980 · S/N 310R1801 N1970FSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 33701243 N1970NDaniel Arthur D · Fishtail, MTBuilt 1969 · S/N E-186

Back to AD 2000-23-21