Skip to content

Registered aircraft · 22,413

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.

N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733 N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043 N280NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844014 N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230 N280TCNobles Gary D · Fairview, TXS/N 28-21227 N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137 N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101 N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296 N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052 N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237 N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728 N2815FKlopping William E · Apple Valley, CAS/N 28-7916438 N2815MEd Hamilton Investments Lc · Richmond, TXBuilt 1977 · S/N 28R-7803147 N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451 N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452 N2816PNetz Aviation LLC · Grand Ledge, MIS/N 28-7990453 N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297 N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455 N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456 N2817RHunt Loren M · Nevada, MOBuilt 1969 · S/N 28R-35298 N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459 N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462 N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466 N2818TLb33 LLC · Helena, MTBuilt 1972 · S/N 28-7225239 N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467 N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469 N2819FMacair LLC · Kennesaw, GABuilt 1979 · S/N 28R-7918156 N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227 N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280 N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665 N281CAFarrugia Joe · Cleveland, TXBuilt 1979 · S/N 28R-7918121 N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111 N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323 N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130 N281NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844015 N281RABluewater Airmotive Corp · Wilmington, DEBuilt 1976 · S/N 28-7615352 N281TWSkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881091 N2820DAbdullah Ibrahim M · Las Vegas, NVS/N 28R-7931210 N2820JChabot Nicholas · West Hartford, CTBuilt 1979 · S/N 28-7911189 N2820NMontana Tvl Aviation LLC · Kalispell, MTBuilt 1979 · S/N 28-7911191 N2821GH&M Air LLC · Metamora, MIBuilt 1979 · S/N 32-7940137 N2822GWorsham Investments LLC · Tulsa, OKBuilt 1979 · S/N 28-7911137 N2822STwo Two Sierra LLC · Austin, TXBuilt 1979 · S/N 28-7990470 N2822YThayer Robert N · Portola, CABuilt 1979 · S/N 28-7990471 N28235Registered aircraftBuilt 1969 · S/N 28-11253 N2823DOloteo Dennis R Jr · San Antonio, TXBuilt 1979 · S/N 28-7990472 N2823TAircraft Restoration LLC · Valparaiso, INBuilt 1972 · S/N 28R-7235140 N2824DSchaible John A · Moneta, VAFirst renewal noticeBuilt 1979 · S/N 28R-7918159 N2824YForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28R-7918161 N28251Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843729

Back to AD 87-08-08 R3