OpenAirDocs.org
AD 2000-23-21

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
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.

N305APhiladelphia Glider Council Inc · Hilltown, PABuilt 1951 · S/N 23182N305ABL-19 Birddog LLC · Huntington, INBuilt 1951 · S/N 21290N305ADScreaming Rubber Chicken Aviation LLC · Boise, IDS/N 21783N305AFPlaskon Kate Trustee · San Rafael, CABuilt 1999 · S/N 305AFN305APDoc Joey Inc · Wilmington, DES/N 0500N305BCProp & Wing Aviation Inc · Humble, TXBuilt 1982 · S/N CE-993N305BJJones Marvin B · Farmerville, LABuilt 1951 · S/N 22465N305BKRegistration Pending · Delta, OHRegistration pendingBuilt 1985 · S/N 25-0885N305CABrinker Joe E Jr · Little Hocking, OHBuilt 1964 · S/N TC-584N305CDModern Industrial Services Inc · Beaumont, TXBuilt 2006 · S/N 1966N305CMLegacy Flight Museum · Rexburg, IDBuilt 1957 · S/N 24558N305CRSeewald Jeffrey W · Great Bend, KSBuilt 1950 · S/N 21483N305DFPrecision Delta Corp · Ruleville, MSBuilt 1950 · S/N 21163N305EPPickard Erik · Deer Park, TXBuilt 1982 · S/N 25-0656N305FStockdale Aviation LLC · Crawford, COBuilt 1963 · S/N 18254903N305FUDustoff LLC · Concord, NHBuilt 1951 · S/N 21741N305GTomahawk Aviation LLC · Reno, NVBuilt 1983 · S/N 25-0760N305GDGlyn Dwr Air LLC · Kalispell, MTS/N 25-0524N305GGChayes Daniel A · Mercersburg, PABuilt 1979 · S/N 25-0286N305HStat Care Clinics LLC · Baton Rouge, LABuilt 1986 · S/N 25-1062N305HPDlc Sky LLC · North Miami, FLS/N E-3852N305JBKoning Ryan W · Williams, AZS/N 25-1067N305JKOrcutt John Edward · Tucson, AZS/N 25-0214N305JPPattison Jeffrey L · Glasgow, MTBuilt 1951 · S/N 21789N305JTWinniwolfe Holdings LLC · Wolfeboro, NHBuilt 1986 · S/N 25-1075N305KFlorida Flying Tigers LLC · Tampa, FLBuilt 1979 · S/N 25-0252N305KMKeim Jeffrey R · Moorhead, MNBuilt 1979 · S/N 25-0285N305KWPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N U20604213N305L305l Air Holdings LLC · Phoenix, AZS/N 25-0616N305LSHill Karin V · Georgetown, TXBuilt 1982 · S/N 25-0678N305LWProfessional Flyers Corp · Wilmington, DEBuilt 1980 · S/N 25-0388N305MHartley John · Kissimmee, FLBuilt 1987 · S/N 25-1140N305MKCoughlin Enterprises Inc · Central Point, ORBuilt 1979 · S/N 25-0264N305MMSegal Marshall B · Chicago, ILBuilt 1980 · S/N EA-188N305MRRoberts Bruce D · New London, PAFirst renewal noticeBuilt 1965 · S/N 2011N305MVGreatest Generation Naval Museum · Colorado Springs, COBuilt 1951 · S/N 22455N305NHRoesch John M · Largo, FLS/N 25-0718N305PE305pe LLC · Lakewood Ranch, FLS/N 25-0818N305PFSale Reported · Crystal, MNSale reportedBuilt 1980 · S/N 25-0486N305PJBradley Alana J · Joliet, ILBuilt 1986 · S/N 25-1020N305PRGlahn Guy R · Redmond, ORS/N 25-1206N305REasterling William D · Salisbury, NCBuilt 1979 · S/N 25-0231N305RHGreater Boston Soaring Club Inc · Sterling, MABuilt 1962 · S/N 612956N305RMPuglielli Jeffrey W · Bolingbrook, ILS/N 25-0746N305RPMiami Romeu Papa LLC · Miami Beach, FLBuilt 2024 · S/N 10349N305RTMorris Alysse · Rapid City, SDS/N 25-0051N305SESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 25-0377N305SLSealand Airways Miami LLC · Miami, FLBuilt 1968 · S/N 185-1433N305SMWinston James Eldon Jr · Granbury, TXBuilt 2006 · S/N 41688N305SU305su LLC · Rexburg, IDBuilt 1961 · S/N 305M-0007
Back to AD 2000-23-21