Skip to content

Registered aircraft · 47,133

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.

N3633UBrasher Cecil V Jr · Jamestown, NCBuilt 1963 · S/N 18255033 N36345Altair Aircraft LLC · Gainesville, FLBuilt 1978 · S/N 34-7870321 N3635CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 31133 N36362Sale Reported · WitshireSale reported, pending cancellationBuilt 1955 · S/N 31691 N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748 N36369Eastern Aeroworks LLC · Punxsutawney, PABuilt 1978 · S/N 34-7870323 N3636AScull Adam C · Hockessin, DEBuilt 1978 · S/N E-1399 N3636CSale Reported · Galena, KSSale reportedBuilt 1966 · S/N 310K0137 N3636HLasar Inc · Lakeport, CABuilt 1980 · S/N 25-0433 N3636TFortier Stanley · Chico, CAS/N EA-18 N3636UVandeman Jack P · Norco, CABuilt 1963 · S/N 18255036 N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136 N36371Akridge Jeffry J · Moses Lake, WAS/N 34-7870324 N3639DOlah Michael J DBA · Mazomanie, WIBuilt 1956 · S/N 35339 N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039 N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139 N363BShoal Properties LLC · Bokeelia, FLBuilt 1957 · S/N D-5087 N363CTAlpha Mike Aviation LLC · Lakeville, MNBuilt 2015 · S/N 4232 N363DFTradewind Capital LLC · Whitefish, MTBuilt 2025 · S/N 10620 N363JVRead Andrew R · Milwaukee, WIBuilt 1976 · S/N 18502991 N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000 N363KCPapa Golf Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2457 N363KKFisher David J · La Conner, WABuilt 2009 · S/N 3379 N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143 N363NCN363nc Corp Trustee · Wilmington, DEBuilt 2007 · S/N 3449363 N363PMFlying Luvbug LLC · Grafton, WIS/N 4368 N363RMankind Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E-97 N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046 N363SCOcm Aviation LLC · Buckeye, AZBuilt 2004 · S/N 1209 N363SRJolly Raymond V · Hillsborough, NJBuilt 2006 · S/N 2226 N363T1800sky LLC · Henderson, KYBuilt 1963 · S/N TC-416 N363WHPwc Aviation LLC · Omaha, NEBuilt 2018 · S/N 1771 N363WTJ S Aviation LLC · Rochester, MIBuilt 2023 · S/N 9290 N363ZN363z Flyers LLC · Lenexa, KSBuilt 1960 · S/N D-6526 N364Farmers Bank · Parsons, TNBuilt 1976 · S/N P3370243 N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880 N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040 N3641DAdkins Steven · Oriental, NCBuilt 1956 · S/N 35341 N3642CMcmahan Bryan · Gakona, AKBuilt 1954 · S/N 31140 N3642DCorre Training Industries Inc · Federal Way, WABuilt 1956 · S/N 35342 N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042 N3643BCoffelt Kelly L · Bend, ORBuilt 1956 · S/N 32347 N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043 N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044 N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045 N3646UGarner Lynn · Preston, IDS/N 18255046 N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146 N3647CSmith Kristopher D · Wickenburg, AZBuilt 1954 · S/N 31145 N3647DVmc Aviation · Upland, CAS/N 35347 N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047

Back to AD 2000-23-21