Skip to content

Registered aircraft · 59

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-14-08') 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-14-08') 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-14-08')
    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-14-08')
  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-14-08')
  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-14-08')
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.

N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049 N141TCEhs Aircraft LLC · Wilmington, DEBuilt 1984 · S/N 42-5501021 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N158MHMansfield Heliflight Inc · Milton, VTS/N 42-5527006 N190CAJag Air LLC · New Castle, DES/N 42-8001028 N225MBCheyenne III Flyers LLC · New York, NYBuilt 1983 · S/N 42-8001102 N242RAJohnston Properties LLC · Garden City, KSS/N 42-8001003 N245JRAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501019 N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015 N321LHMullins Michael · Seaford, DEBuilt 1985 · S/N 42-5527012 N332SAPharmair LLC · Jackson, MSBuilt 1985 · S/N 42-5527025 N3644BSeptember Bravo Enterprises LLC · West Olive, MIBuilt 1984 · S/N 425501014 N370AB4 Boys Air LLC · Rockwall, TXBuilt 1984 · S/N 425527008 N37KWBroco Viii LLC · Tipton, INBuilt 1989 · S/N 425527039 N395DRWings International II LLC · Wilmington, DEBuilt 1981 · S/N 42-8001065 N396CTFlight Assets LLC · Dover, DEBuilt 1987 · S/N 42-5501044 N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021 N3SPAvon Aero Supply Inc · Orlando, FLBuilt 1984 · S/N 42-5527018 N400ELEmmair LLC · Greenbrier, ARBuilt 1989 · S/N 42-5527041 N400LRKelly Aero LLC · Montgomery, ALBuilt 1984 · S/N 42-5527003 N400PBPlane Easy LLC · Lake Worth, FLBuilt 1984 · S/N 425527005 N400VBKelleher Corporation · San Rafael, CABuilt 1985 · S/N 42-5527002 N401JTN401jt LLC · Denver, COS/N 42-5501023 N41182Piper Aircraft Inc · Vero Beach, FLBuilt 1985 · S/N 42-5501024 N411BGSeas To See LLC · Nacogdoches, TXBuilt 1984 · S/N 42-5527004 N425RRValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 42-5501008 N42ZCCrest View Aero LLC · Rancho Cordova, CABuilt 1981 · S/N 428001039 N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027 N444CYShuman Farms Inc · Reidsville, GABuilt 1984 · S/N 42-5501025 N448CASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 425527034 N450MWValiair Ltd Co Trustee · Casper, WYS/N 42-5527013 N46HLGsp Air LLC · Sparta, NJBuilt 1985 · S/N 42-5527017 N47ZGJep Air LLC · Jackson, WYBuilt 1985 · S/N 42-5527031 N486MTNavy 8686 LLC · Boston, MABuilt 1985 · S/N 425527029 N500LMLets Fly Somewhere LLC · Canyon, TXBuilt 1984 · S/N 42-5527016 N508PMTvc Av LLC · Jacksonville, FLBuilt 1984 · S/N 42-5527021 N57VEN64fd LLC · Wilmington, DES/N 42-5527027 N5SYDialysis Clinic Inc · Nashville, TNBuilt 1981 · S/N 42-8001069 N627PCAir First LLC · Kalispell, MTBuilt 1984 · S/N 425501010 N690ECheyenne Development Associates 2 LLC · Dover, DEBuilt 1984 · S/N 42-5501020 N69PCValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 42-8001023 N706JRDodson International Parts Inc · Rantoul, KSS/N 42-5501050 N7139BNortheast Travel Corp · Brooklyn, NYBuilt 1980 · S/N 42-8001042 N7222FGriffin Aviation LLC · Great Falls, VABuilt 1987 · S/N 42-5527036 N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046 N778SGValiair Ltd Co Trustee · Casper, WYBuilt 1983 · S/N 42-5501006 N82PGAugustus Air LLC · Mc Allister, MTBuilt 1981 · S/N 42-8001070 N8RYAviation Sales & Charter LLC · Dover, DES/N 42-8001036 N9091JDavis Aviation Inc · Brandon, MSBuilt 1986 · S/N 42-5501035

Back to AD 2000-14-08