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.

N306TBApex Aviation Holding LLC · Kalispell, MTBuilt 1982 · S/N 340A1537 N306TCN306tc LLC · Greenwich, CTBuilt 1976 · S/N 18503061 N3070LClark Kenneth N · Tempe, AZBuilt 1965 · S/N 310J0070 N3070TJacobson Jeffery L · Manning, NDBuilt 1987 · S/N EA-462 N3070WEtw Holdings Corp · Owego, NYBuilt 1973 · S/N TC-1626 N3070YPearce Andrew R · Raleigh, NCBuilt 1962 · S/N 18254070 N3070ZGarber Greg · Redmond, ORBuilt 1979 · S/N 28R-7931174 N3071CSimpkins Randolph J · Eagan, MNBuilt 1958 · S/N D-5727 N3071FRees Ryan G · Loa, UTS/N 18257171 N3071LDishburger Samuel T · Westfield, INBuilt 1965 · S/N 310J0071 N3071NBunkie Bird LLC · Tucson, AZS/N 28R-7931060 N3071QNichols Waylon · Copeland, KSBuilt 1967 · S/N 18258071 N3072WJennings Dennis · Sequim, WABuilt 1973 · S/N E-492 N3072XParsons Keir Wurzel D · Naples, IDBuilt 1979 · S/N 28R-7931137 N3073FLuther Arnold D · Las Vegas, NVBuilt 1966 · S/N 18257173 N3073LSheakley John W DBA · Meadville, PABuilt 1965 · S/N 310J0073 N3073MRobinson Robert F G · Round Rock, TXBuilt 1977 · S/N 28R-7803164 N3073YWf Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18254073 N30746Tribe Of Judah Motorcycle Ministries Inc · Humble, TXBuilt 1978 · S/N 34-7870231 N3074JMehling Robert C · Hardin, MTS/N T18803600T N3074QGriffin John O · Driggs, IDBuilt 1967 · S/N 18258074 N3074YIronman Welding Inc · Rifle, COBuilt 1962 · S/N 18254074 N3075FTurpen Kraig Aaron · Fredericksburg, TXBuilt 1966 · S/N 18257175 N3075LAlvis Michael E · Parkton, NCS/N 310J0075 N3075PWjs Inc · Greeneville, TNBuilt 1999 · S/N TH1887 N3075QDickerson Anthony S · San Tan Valley, AZBuilt 1967 · S/N 18258075 N3075XOrthoredlands Leasing LLC · Redlands, CAFirst renewal noticeBuilt 1987 · S/N EA-466 N3075YAir Eagle LLC · Rome, GABuilt 1979 · S/N 21063169 N3076TPoint Two Six Avation LLC · Scottsdale, AZBuilt 1987 · S/N CE-1149 N30771Dodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N TH-1518 N30774Stucco Supply Co Of San Jose Inc · San Jose, CABuilt 1988 · S/N EA-477 N30777Huff Charles Christopher · Midland, TXBuilt 1973 · S/N 21059959 N3077FBlake Jason E · Shreveport, LABuilt 1966 · S/N 18257177 N3077HAir Frame Worx LLC · Wilmington, DEBuilt 1987 · S/N CE-1154 N3077KBaldus Scott William · Waxhaw, NCBuilt 1985 · S/N CE-1070 N3077U3077u LLC · Dallas, TXBuilt 1986 · S/N CE-1085 N3077WWipaire Inc · South Saint Paul, MNBuilt 1973 · S/N E-496 N3077ZBravo Air LLC · Troy, MIBuilt 1987 · S/N TH-1516 N30787Jetsons Holdings LLC · Birmingham, ALBuilt 1987 · S/N TH-1521 N3078HHorn H Fred · Cedar Rapids, IABuilt 1988 · S/N CE-1229 N3078JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N 18803602T N3078YDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N E-2386 N30797Johnson Alan L · Pikeville, KYBuilt 1987 · S/N CE-1185 N3079BHarris William C · Gladstone, NJBuilt 1987 · S/N CE-1172 N3079CTre Aviation Corp · Wilmington, DEBuilt 1958 · S/N D-5759 N3079FMackay Chadd P · Spokane Valley, WABuilt 1966 · S/N 18257179 N3079LTff Inc · Parma, MIBuilt 1965 · S/N 310J0079 N3079WFerr Air Ltd · Southampton, PABuilt 1987 · S/N E-2388 N3079YAustin Bill · Laurel, MTBuilt 1987 · S/N CE-1176 N307AHadaway Phillip Allen · Hooks, TXBuilt 2006 · S/N 1913

Back to AD 2000-23-21