Skip to content

Registered aircraft · 1,915

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-22-01-R1') 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-22-01-R1') 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-22-01-R1')
    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-22-01-R1')
  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-22-01-R1')
  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-22-01-R1')
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.

N69084Konen Rock Products Inc · Milton Freewater, ORBuilt 1982 · S/N LA-157 N690GLathem Russell Glen · Dalhart, TXBuilt 1972 · S/N LW-34 N690KABank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N LJ1101 N690SCN690sc One LLC · Dover, DEBuilt 1983 · S/N BB-1139 N692WGuardian Flight LLC · Lewisville, TXBuilt 2003 · S/N LJ-1692 N694KMCarling Technologies Inc · Plainville, CTS/N BB-1922 N697PStaker & Parson Co · Ogden, UTBuilt 1985 · S/N BB1217 N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83 N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658 N699CCC & C Market Research Inc · Fort Smith, ARBuilt 1999 · S/N LJ-1553 N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10 N699TPDoodle Aviation LLC · Burlington, NCBuilt 1985 · S/N FA-73 N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214 N6KZDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N LJ-238 N6VJN6vj LLC · Coleman, FLS/N LA88 N70Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-5 N7000BBeechcraft Heritage Museum Inc · Tullahoma, TNS/N LM-01 N7007GDynamic Aviation Group Inc · Bridgewater, VAS/N LM-02 N70088School Of Missionary Aviation Technology · Ionia, MIS/N LM-06 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N700DHGramer Air II LLC · Bloomfield Hills, MIBuilt 1974 · S/N LW-114 N700LXLimpia Logistics LLC · Midland, TXBuilt 1999 · S/N BB-1657 N700NAAtlanta Air Charter Inc · Kennesaw, GABuilt 1994 · S/N BB-1491 N700WWAces Full Inc · Deadwood, SDBuilt 1985 · S/N LJ-653 N700ZAti Aviation LLC · Johnstown, PAS/N BB-1920 N7010LDynamic Aviation Group Inc · Bridgewater, VAS/N LM-07 N7014LDynamic Aviation Group Inc · Bridgewater, VAS/N LM-10 N7018FDynamic Aviation Group Inc · Bridgewater, VAS/N LM-13 N701AXHeli Ranch LLC · Auburn, WABuilt 1987 · S/N FA-116 N701NCNorth Country Aviation Inc · Gaylord, MIBuilt 1972 · S/N LW-18 N701XPFlight Partners 2 LLC · Lincoln, NEBuilt 1979 · S/N LJ-826 N70292Dynamic Aviation Group Inc · Bridgewater, VAS/N LM-18 N702MAZion Asset Management LLC · Saint Clair Shores, MIS/N BB-1010 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49 N70356Dynamic Aviation Group Inc · Bridgewater, VAS/N LM-25 N7036LDynamic Aviation Group Inc · Bridgewater, VAS/N LM-26 N7038YDynamic Aviation Group Inc · Bridgewater, VAS/N LM-28 N7039TDynamic Aviation Group Inc · Bridgewater, VAS/N LM-30 N7043NDynamic Aviation Group Inc · Bridgewater, VAS/N LM-38 N7047DDynamic Aviation Group Inc · Bridgewater, VAS/N LM-41 N7052XDynamic Aviation Group Inc · Bridgewater, VAS/N LM-45 N7052YDynamic Aviation Group Inc · Bridgewater, VAS/N LM-47 N7062WDynamic Aviation Group Inc · Bridgewater, VAS/N LM-49 N7063DDynamic Aviation Group Inc · Bridgewater, VAS/N LM-50 N70648Dynamic Aviation Group Inc · Bridgewater, VAS/N LM-53 N7064QDynamic Aviation Group Inc · Bridgewater, VAS/N LM-52 N7066XDynamic Aviation Group Inc · Bridgewater, VAS/N LM-54 N7067SDynamic Aviation Group Inc · Bridgewater, VAS/N LM-55 N7069FDynamic Aviation Group Inc · Bridgewater, VAS/N LM-56 N7078JLiberty University School Of Aeronautics · Lynchburg, VAS/N LM-67

Back to AD 87-22-01 R1