Skip to content

Registered aircraft · 215

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:87-04-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-04-01') 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:87-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-04-01')
  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:87-04-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-04-01')
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.

N1005BRucker Casey J · West Linn, ORBuilt 1987 · S/N 4608091 N100GFMenke Rex A · Medical Lake, WABuilt 1986 · S/N 46-8608060 N100HDLong Trace LLC · Madison, WIBuilt 1985 · S/N 46-8608003 N106LBSix Lima Bravo LLC · Geary, OKBuilt 1985 · S/N 46-8508093 N107PMHaase Jason M · Hastings, NEBuilt 1986 · S/N 46-8608023 N10PPWendellco LLC · Harlingen, TXBuilt 1983 · S/N 46-8408011 N111NMHineman Land & Cattle Inc · Scott City, KSBuilt 1984 · S/N 46-8508006 N11222Aircraft Partner Holdings Inc Trustee · BerlinBuilt 1986 · S/N 468608033 N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019 N121GPTaft Diversified LLC · Springfield, ILBuilt 1985 · S/N 46-8508086 N1228Hodges Farms LLC · Grain Valley, MOBuilt 1987 · S/N 4608092 N124CCWeaks Taylor Madison · Houma, LABuilt 1984 · S/N 46-8408036 N12EVDaedalus LLC · Little Rock, ARBuilt 1985 · S/N 46-8508065 N135USJohn Hale · Temple, TXBuilt 1987 · S/N 46-08078 N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081 N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057 N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032 N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002 N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107 N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130 N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074 N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045 N200WWRoark LLC · Bend, ORBuilt 1985 · S/N 46-8508035 N201GWInternational Air Services Inc Trustee · Carson City, NVBuilt 1985 · S/N 468508055 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020 N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N22FXWoodland Aviation LLC · Belmont, MIBuilt 1985 · S/N 46-8508043 N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097 N2569YDavidson James E · Bothell, WAS/N 46-8508104 N25CXVisair II LLC · Canton, OHBuilt 1985 · S/N 46-8508100 N25LHCole Aviation LLC · Wichita, KSBuilt 1985 · S/N 46-8508070 N26030Lessing Aviation LLC · Denver, COBuilt 1985 · S/N 46-8508107 N269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065 N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043 N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045 N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015 N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004 N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109 N31BXWhite Robert · Woodlawn, TNBuilt 1986 · S/N 46-8608031 N323FLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1985 · S/N 468508096 N328EMConcierge Diamonds Inc · Los Angeles, CABuilt 1985 · S/N 46-8508087 N330HTPhelan Dennis M · Goodyear, AZS/N 468408010 N350BRMmhc Logistics LLC · Memphis, TNS/N 4608001 N352HAIcs Air LLC · Saint James, MNS/N 46-8608034 N355DCRyan John T · Salina, KSBuilt 1984 · S/N 46-8408079 N357CSN357c5 LLC · Clinton, MOBuilt 1984 · S/N 46-8508026 N357MMClark Melvin G · Sunnyvale, TXBuilt 1985 · S/N 46-8508092

Back to AD 87-04-01