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.

N3345RJennings Mamie M · Springfield, ILBuilt 1967 · S/N 18258645 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3345XTurel Gary J · Tigard, ORS/N 310L-0195 N3346LHarper Matthew Clay · Anchorage, AKS/N 185-1274 N3346MBromberek Gene T · Cumming, GABuilt 1977 · S/N 28R-7803136 N3346RGonzalez Oscar · Bedford, TXBuilt 1968 · S/N 18258646 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N33475Excelsior Solutions Inc · Pinehurst, NCBuilt 1975 · S/N 34-7570123 N3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZBuilt 1966 · S/N 18257347 N3347LAcumen Aerotech LLC · Rogers, TXBuilt 1967 · S/N 185-1275 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348UCollins Christopher E · Bluford, ILBuilt 1963 · S/N 18254748 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3349ADoherty David R · Thief River Falls, MNBuilt 1970 · S/N CE-306 N3349DWeninger Gregory M · Burrton, KSBuilt 1955 · S/N 32147 N3349FMaxfield David · Greenville, SCBuilt 1966 · S/N 18257349 N3349JRegistration Pending · Quincy, OHRegistration pendingS/N T18803632T N334ABerry Darrel · Camden, TNBuilt 1953 · S/N 34-124 N334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962 N334CPRws Aviation LLC · Indianapolis, INBuilt 1977 · S/N E-1003 N334DBrady Michael H Trustee · Healdton, OKBuilt 1993 · S/N CE-1756 N334DATwo Knuckleheads & An Airplane LLC · Georgetown, TXBuilt 2009 · S/N 3396 N334FLChampionx LLC · Sugar Land, TXBuilt 2004 · S/N 290334 N334HCCannon Harold · Utica, KYS/N 34-69 N334HPN334hp LLC · Sheridan, WYBuilt 1974 · S/N CE-519 N334JDGolden Bear Properties LLC · Lakeside, AZBuilt 1993 · S/N CE-1718 N334JVTharp Donald J · Aurora, OHBuilt 1957 · S/N BG-366 N334KWRoberts Dorel Lynn · Sheridan, WYS/N CE-523 N334LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1956 · S/N G-813 N334MBSutherland Scott G · Longmont, COBuilt 1982 · S/N CE-1012 N334MEKline Timothy J · Van Nuys, CABuilt 1963 · S/N CD-625 N334MTBlomquist Mark S · Gardiner, MTBuilt 1962 · S/N CD-520 N334PBConway Brian · Denver, COBuilt 1990 · S/N CE-1543 N334PCMagic Valley Auction LLC · Jerome, IDBuilt 1990 · S/N CE-1534 N334PDCurtis Darrin M · Woodland, CABuilt 1964 · S/N CD-814 N334PWGary Bass Restorations LLC · Monett, MOBuilt 1974 · S/N CE-488 N334RN566rw LLC · Hensley, ARBuilt 1991 · S/N CE-1561 N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837 N334RLButters Brewster S · Port Orange, FLBuilt 1963 · S/N G-12 N334RTHyde Alfred D III · Denton, TXBuilt 1971 · S/N CD-1263 N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691 N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111 N334TFlying Crown Aviation LLC · Fond Du Lac, WIBuilt 1955 · S/N BG-138 N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499 N334TXMagic Mentor LLC · Canyon, TXS/N G-26 N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685 N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331 N334WSStengl William R · Minocqua, WIBuilt 1966 · S/N CE-79 N334YWarner Aric D · Rosamond, CAS/N 18051299

Back to AD 2000-23-21