Skip to content

Registered aircraft · 72,007

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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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.

N32403Blue Skies Flying Services Inc · Lake In The Hills, ILBuilt 1974 · S/N 28-7515148 N32405Hop-Hi Aviation LLC · St Louisville, OHS/N 28-7505057 N32408Dalton Thomas C · Salem, SCBuilt 1974 · S/N 28-7515149 N3240FJ Smith LLC · Lewes, DEBuilt 1967 · S/N 670033 N3240TFrena John A · Pittsburgh, PABuilt 1967 · S/N 17700540 N32413Peterson Paul · Maryville, TNS/N 28-7505058 N32419Registered aircraftBuilt 1974 · S/N 28-7525064 N3241PBravo Partners LLC · Payson, AZBuilt 1957 · S/N 23-1186 N3241RJohnson Edward Wayne · Bloxom, VABuilt 1969 · S/N 28R-31023 N3241TMaggart Daniel J · Winchester, ILBuilt 1967 · S/N 17700541 N32421Anderson Allen D · Goodlettsville, TNFirst renewal noticeS/N 28-7515152 N32425Montgomery Robert L · Kingman, AZBuilt 1974 · S/N 28-7515154 N32426Fly Aviation LLC · Sabetha, KSBuilt 1974 · S/N 28-7505059 N32427Mcfadden Robert K · Port Orange, FLBuilt 1974 · S/N 28R-7535054 N3242CPelski Aviation LLC · Ocala, FLBuilt 1978 · S/N R18200259 N3242FSbflyer LLC · Ooltewah, TNBuilt 1967 · S/N 670035 N3242KPorter Thomas G · San Carlos, CABuilt 1946 · S/N 1235 N3242RRobertson Dale R · Newton, KSBuilt 1982 · S/N 1694 N3242TSt Clair Ronnie M · Cochise, AZBuilt 1967 · S/N 17700542 N32432Kg Elite Vacations LLC · Miami, FLBuilt 1974 · S/N 32-7540040 N32435Nickos Ryan L · Kenosha, WIS/N 28-7525066 N32436Townsend Ricky E · Rogers, ARS/N 28-7525067 N32439Triple R Aviation LLC · Cleburne, TXBuilt 1974 · S/N 28-7515156 N32440Ford Chase Rambo · Montgomery, ALBuilt 1974 · S/N 28-7515157 N32441Registration Pending · Kalispell, MTRegistration pendingS/N 28-7505060 N32444Jtz Aviation LLC · Wilmington, DEBuilt 1974 · S/N 28R-7535057 N3244FKempton Brian J · Huntsville, TXBuilt 1967 · S/N 670037 N3244TCaicedo Oscar E · Garner, NCS/N 17700544 N3244ZGinn Robert Theron · Royston, GABuilt 1959 · S/N 22-7191 N32452Watkins Nathan · Baytown, TXBuilt 1974 · S/N 28-7510022 N3245QTandy Richard L · North Chili, NYBuilt 1974 · S/N 28-7515159 N3245RA & W Cattle Co · Flippin, ARBuilt 1969 · S/N 28R-31019 N32462Av8 Flight Services LLC · Wichita Falls, TXBuilt 1974 · S/N 28-7515162 N32466Oh Heung Taeg · Olney, MDBuilt 1974 · S/N 28-7505062 N32469Dufresne Justin Barth · Temple City, CABuilt 1974 · S/N 28R-7535059 N3246TFears Edwin G III · Trafalgar, INBuilt 1967 · S/N 17700546 N32475Eikenberry Don A · Palouse, WABuilt 1974 · S/N 28-7525072 N32478Sidney Aviation LLC · Sidney, NEBuilt 1974 · S/N 28-7515164 N3247FWilliams Matthew D · Xenia, OHS/N 670040 N3247RArrowood Bradley W · Winston Salem, NCBuilt 1970 · S/N 28R-31111 N3247TBeeda Mark A · West Palm Beach, FLBuilt 1967 · S/N 17700547 N32480Alphakiloecho LLC · Somerville, MABuilt 1974 · S/N 28-7505063 N32481Flyboy Fantasy Inc · South Lake Tahoe, CABuilt 1974 · S/N 28R-7535061 N32483Showah Jason M · Brentwood, TNBuilt 1974 · S/N 28R-7535062 N32486Parr Bobbie D · Mount Pleasant, TXBuilt 1974 · S/N 28-7515167 N32488Registered aircraftBuilt 1974 · S/N 28-7515168 N3248PAero Spectra Corp · Boulder, COS/N 23-1193 N3248WKeifer Ronald C · Port Orange, FLBuilt 1965 · S/N 32-66 N32490Jackson Charles A · Winchester, KYBuilt 1974 · S/N 28-7515169 N32492Doyle Dylan D · Cerrillos, NMBuilt 1974 · S/N 28R-7535063

Back to AD 87-10-06 R1