Skip to content

Registered aircraft · 22,416

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

N9251EArrowpoint Investments LLC · Mountain Brk, ALBuilt 1994 · S/N 3213084 N9251JGholami Amir K · Santa Rosa, CABuilt 1966 · S/N 28-3326 N9251WHering Lloyd L · Boulder, COBuilt 1967 · S/N 28-10922 N9252JFlying Wrenches LLC · Cairo, NEBuilt 1966 · S/N 28-3327 N9253MBlue Eagle Air LLC · Singer Island, FLBuilt 1985 · S/N 32R-8513010 N9253NJjd LLC · Middleton, WIS/N 32R-8013065 N9254KBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7690237 N9254WVan Metre Steven · Bel Air, MDBuilt 1967 · S/N 28-10926 N9255CD&J Aviation LLC · Apopka, FLBuilt 1978 · S/N 28-7890393 N9256CBluegrass Aviation LLC · Clarksville, TNBuilt 1978 · S/N 28-7890394 N9256DGonitzke Ross J · Detroit Lakes, MNBuilt 1995 · S/N 2890227 N9257CAcorn Aviation LLC · Saint Charles, ILBuilt 1978 · S/N 28-7890395 N9257JWojtecki Chris R · Florissant, COBuilt 1966 · S/N 28-3333 N9258CBack Forty Flying Club Inc · Roanoke, INBuilt 1995 · S/N 2843002 N9258DFlansburg Robert D · Middletown, DEBuilt 1995 · S/N 3246007 N9258JHummingbird Avaition LLC · Columbus, INBuilt 1966 · S/N 28-3334 N9258NKma Aircraft Dream LLC · Osteen, FLBuilt 1995 · S/N 28-43014 N9258WM And T Aviation LLC · Hampstead, MDBuilt 1967 · S/N 28-10930 N9259JDave Flight LLC · Mccook, NEBuilt 1966 · S/N 28-3335 N9259RAndiamo Aviation LLC · Stonecrest, GABuilt 1995 · S/N 32-46010 N925MKOates Douglas E · Elgin, SCBuilt 1966 · S/N 28-3325 N925PASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843288 N925TCJarvis Bradley A · North Port, FLBuilt 1981 · S/N 32R-8129013 N92605Sarratt Curtis H · Annapolis, MDS/N 2844002 N9260TCanoace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8616033 N9260WFlo-Co2 · Gardendale, TXBuilt 1967 · S/N 28-10932 N92610Adventure Flight Aviation Inc · Springdale, ARBuilt 1995 · S/N 3246014 N9261JLear Steven J · Rockville, INBuilt 1966 · S/N 28-3337 N9261WFlightshare Holdings LLC · Lewes, DEBuilt 1967 · S/N 28-10933 N9262CRick Aviation Inc · Newport News, VABuilt 1978 · S/N 28R-7837183 N9263JHarrod Andrew A Jr · El Segundo, CABuilt 1966 · S/N 28-3339 N9263KCrook Michael J · Paradise, UTBuilt 1976 · S/N 32R-7680205 N9263LSkyhawk Flying Club Inc · Franklin Grove, ILBuilt 1996 · S/N 2843023 N9264AArcher II Holding Company LLC · Coral Gables, FLBuilt 1985 · S/N 32R-8613003 N9265BMlr Aviation LLC · Tavernier, FLBuilt 1996 · S/N 3246029 N9265JStuvland Christopher · Pendleton, ORBuilt 1966 · S/N 28-3341 N9265PWard Benny · Raleigh, NCS/N 2843024 N9266JTaccone Glenn R · Henderson, NVBuilt 1966 · S/N 28-3343 N9266KRestrepo Aircraft Corp · Fort Lauderdale, FLBuilt 1996 · S/N 2844004 N9266WGunderson Richard Joseph · San Marcos, CABuilt 1967 · S/N 28-10939 N9267JLarson Christopher J · Saint Maries, IDBuilt 1966 · S/N 28-3344 N9267RN9267r LLC · Pittstown, NJBuilt 1996 · S/N 3246025 N9268JRegistered aircraftBuilt 1966 · S/N 28-3345 N9269CMcmillin George T · Bradenton, FLBuilt 1978 · S/N 32-7800002 N9269FSmith Outdoor Adventures LLC · Panama City, FLBuilt 1996 · S/N 3246039 N9269GLauterbach Dean C · Newton, IABuilt 1996 · S/N 2843021 N9269JHelm Daniel E · Portland, ORBuilt 1966 · S/N 28-3346 N9269QAero-Tech Services Inc · Lititz, PABuilt 1996 · S/N 2843031 N9269WHimmel Air LLC · Itasca, ILBuilt 1967 · S/N 28-10942 N926BBBb Air · Stuart, FLBuilt 1978 · S/N 32-7840085

Back to AD 87-08-08 R3