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.

N305TCjn Enterprises LLC · Elbert, COBuilt 1973 · S/N TE-952 N305TAPlanes Of Fame Air Museum · Chino, CABuilt 1951 · S/N 22443 N305VVPeeled Egg Aviation LLC · Santa DomingoBuilt 2020 · S/N 2134 N305WBCardinal Aviation LLC · Charles City, VABuilt 1967 · S/N P206-0386 N305WRKnudsvig Travis · Waterloo, IABuilt 1973 · S/N TC-1591 N305WWObrien Aviation Inc · Port Orange, FLBuilt 1969 · S/N CE-266 N305XWallitner Aviation & Restoration LLC · Bremerton, WAS/N 6132C N305ZReid William R Jr · Clarksburg, WVBuilt 1960 · S/N CD-200 N3060QYarg Tap LLC · Midland, TXBuilt 1967 · S/N 18258060 N3060TPalumbo Henry R · Novato, CABuilt 1979 · S/N 28R-7931087 N3060WRegistration Pending · Ojai, CARegistration pendingBuilt 1973 · S/N E-488 N30619Wrpl LLC · Mountain Brk, ALBuilt 1978 · S/N 34-7870467 N3061CTharp Aerospace LLC · Charleston, SCBuilt 1958 · S/N D-5757 N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261 N3061FTaber Deane W · Weirsdale, FLBuilt 1966 · S/N 18257161 N3061TAdventure Lab Aviation LLC · Saint George, UTBuilt 1979 · S/N 28R-7931088 N3062FJohnson Sean D Trustee · Fresno, CABuilt 1966 · S/N 18257162 N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263 N3063FT J Croach Llp · Post Falls, IDS/N 18257163 N3063NConstantinides Chris · Chula Vista, CABuilt 1979 · S/N 28R-7931058 N3063WReich Michael A · Woodside, CABuilt 1998 · S/N EA625 N30640Christianson Cleet M · Enumclaw, WABuilt 1978 · S/N 28R-7803369 N30644Registered aircraftBuilt 1973 · S/N 21059949 N3064DLebron R Luke · Gulfport, MSS/N 35264 N3064WDavid And Shirley Houchin LLC · Crescent City, FLBuilt 1973 · S/N D-9553 N3064YStemper Pete L · Madison, SDS/N 18254064 N3065FHinds Frank E · San Angelo, TXBuilt 1966 · S/N 18257165 N3065QSuchy Michael R · Murrieta, CABuilt 1967 · S/N 18258065 N3066CBarham Micheal · Bluffton, OHBuilt 1958 · S/N D-5719 N3066DN3066d LLC · Pompano Beach, FLBuilt 1998 · S/N TH-1866 N3066QMeyer Vernon C · Westlake, LABuilt 1967 · S/N 18258066 N3067CGoncharov Serge S · Monroe, NCBuilt 1958 · S/N D-5731 N3067EGlass Bruce D · Crystal Lake, ILBuilt 1982 · S/N 18268231 N3067YRegistration Pending · Bluffdale, UTRegistration pendingBuilt 1962 · S/N 18254067 N3068FLehrman Walter M · Reedley, CABuilt 1966 · S/N 18257168 N3068LMirage Air Ltd · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 310J0068 N3068QTurbo Arrow IV LLC · Nibley, UTBuilt 1979 · S/N 28R-7931074 N3068WSneebler Transport LLC · Burke, VABuilt 1973 · S/N E-490 N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269 N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169 N3069QMarin Alberto · Mc Neal, AZS/N 18258069 N306BZCoast Flight Training & Management Inc · San Diego, CABuilt 2014 · S/N 2258 N306CDDesantis Michael J · Port Orange, FLBuilt 2005 · S/N 1355 N306CPFe Xy LLC · Leesburg, VABuilt 2008 · S/N 3055 N306DCEngeman Charles E · Charlotte, NCBuilt 2002 · S/N 0366 N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544 N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419 N306RSCorsair Aviation Holdings LLC · Orange Park, FLBuilt 2019 · S/N 4743 N306SRElevate Air Service LLC · Montrose, COBuilt 2007 · S/N 2469 N306STKruljiac Jonathan Wade · Kenmore, WABuilt 2006 · S/N 2247

Back to AD 2000-23-21