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.

N3019QHatfield Brothers LLC · Gooding, IDBuilt 1967 · S/N 18258019 N301ABCamber Aviator LLC · Miami, FLBuilt 1979 · S/N 34-7970186 N301ALForhan Michael A · Urbana, OHBuilt 1967 · S/N 3370636 N301BZPin High LLC · Ruston, LABuilt 2005 · S/N E-3642 N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105 N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166 N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891 N301DDRockalong Holdings LLC · Stanton, TXBuilt 1979 · S/N 18503985 N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524 N301EFRegistered aircraftBuilt 2002 · S/N 3RX105 N301FBlue Sky November LLC · Mamaroneck, NYBuilt 2026 · S/N 11303 N301FCTango Charlie Aviation LLC · Thomasville, GABuilt 2023 · S/N 9076 N301GValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 1970 N301GASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18052490 N301GKBrown Water Associates LLC · Monticello, FLBuilt 2020 · S/N 4951 N301HLnc4 Mcx1 LLC · Rexburg, IDBuilt 1999 · S/N 137 N301JFGrace Eric C · Valdosta, GABuilt 1979 · S/N E-1593 N301JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2240 N301MCCharles Michael Maya · Erie, COBuilt 1978 · S/N 18503705 N301MDMoritz Davis Aviation LLC · Edina, MNBuilt 2009 · S/N 3484 N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890 N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334 N301RMSc213 LLC · Van Wert, OHS/N 1205 N301RS2f Trade LLC · Collinsville, TXS/N 21062473 N301RVK6 Construction Inc · Clovis, CABuilt 2004 · S/N 1172 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304 N3020CBrosnan Daniel · Mary Esther, FLBuilt 1958 · S/N D-5685 N3020DAllen Gregory L · Lake View, ALFirst renewal noticeBuilt 1955 · S/N 35220 N3020KGhostwriter Airshows LLC · Hustonville, KYBuilt 1978 · S/N 34-7970099 N3020RHill James C · Grand Saline, TXBuilt 1962 · S/N 320A0020 N3020YJ & T Sullivan Farms Gp · Macon, TNBuilt 1962 · S/N 18254020 N3021FRegistered aircraftBuilt 1966 · S/N 18257121 N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021 N3021TGolden Arrow Transportation · Plainfield, NJBuilt 1964 · S/N 320C0021 N3021WElliott Robert · Hartington, NES/N E-459 N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227 N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123 N3023LBirge Chad W · Alcoa, TNBuilt 1965 · S/N 310J0023 N3023WBoughen James R · Camas, WABuilt 1973 · S/N D-9517 N3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeS/N 18254023 N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124 N3024HMll Air LLC · Kalispell, MTBuilt 1994 · S/N E-2863 N3024QJones Sean D · Adams, TNBuilt 1987 · S/N CE-1110 N3024YTemple Curtis Lee · Porcupine, SDBuilt 1962 · S/N 18254024 N3025DBanducci Debra L Trustee · Bakersfield, CABuilt 1955 · S/N 35225 N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125 N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903 N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126 N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026 N3026TBox William C · Goldsby, OKS/N 320C0026

Back to AD 2000-23-21