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.

N301TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257257 N3020SAndre Frazier LLC · Anacortes, WABuilt 1979 · S/N 28-7916295 N3020WDague John · Monroe, INS/N 28R-7918087 N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137 N3021HWilcox Kenneth P · Peachtree City, GABuilt 1978 · S/N 28-7990200 N3021KKj Cessna LLC · Waxahachie, TXS/N 28R-7918020 N30222Nass Aviation Inc · Selbyville, DEBuilt 1978 · S/N 28-7990086 N3022NWinter Duncan F · Saranac Lake, NYBuilt 1979 · S/N 32R-7985074 N3022UJackson Thomas S · Dunnsville, VAS/N 28R-7918072 N3022YW&M Piper Dakota LLC · Broken Arrow, OKBuilt 1979 · S/N 28-7911149 N30230N30230 Aircraft Holdings LLC · North Charleston, SCBuilt 1978 · S/N 28-7990088 N3023CBlack Cloud Aviators Inc · Dubois, PABuilt 1978 · S/N 28-7990148 N3023DGehin-Scott Gilbert III · Rancocas, NJBuilt 1978 · S/N 28-7911041 N3023KVx Parts LLC · Portsmouth, NHBuilt 1978 · S/N 28R-7918022 N3023TInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-7916299 N30245Downing Douglas E · Troy, TXS/N 32R-7885275 N30249Campbell Donald R · Lawrenceburg, KYBuilt 1978 · S/N 28-7890451 N3024CCash Management Consulting LLC · Granite Springs, NYBuilt 1978 · S/N 28-7990149 N3024DBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7987057 N3024MTremie Chad M · Sulphur, LABuilt 1977 · S/N 28-7890286 N3024NDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1979 · S/N 32R-7987099 N30253Charter Rentals LLC · Mantua, OHS/N 32R-7887274 N3025CWonnenberg Douglas D · Menoken, NDBuilt 1978 · S/N 28-7990150 N3025KWojteczko Jason A · Derby, KSBuilt 1978 · S/N 28R-7918023 N3025LBeacon Aviation Flight Services LLC · Rogers, ARS/N 32R-7987092 N3025NTrue Auto Mart LLC · Belton, SCBuilt 1979 · S/N 32R-7987100 N3025QTamborelli Keith · Kulpmont, PABuilt 1979 · S/N 28-7916285 N30260Schubert Mark J · Watkins, COBuilt 1978 · S/N 28-7890452 N30264Ream Frederick Earl II · Placentia, CABuilt 1954 · S/N 32R-7887276 N3026CDowney Michael E · Dacono, COBuilt 1979 · S/N 32R-7987048 N3026DDirt World LLC · Boulder City, NVS/N 32R-7987058 N3026WAsplund Jonas · Grand, MNBuilt 1979 · S/N 28R-7931126 N3027SG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 28-7990310 N3027VKey Monty W · Seminole, TXBuilt 1979 · S/N 28-7911133 N3028AJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1978 · S/N 32R-7987017 N3028ERegistration Pending · Philadelphia, PARegistration pendingBuilt 1978 · S/N 28-7916168 N3028HRegistered aircraftBuilt 1978 · S/N 28-7911054 N3028MLittle Robert · Ocala, FLBuilt 1978 · S/N 28-7816397 N3029GMckair Inc · Wilmington, DEBuilt 1978 · S/N 28-7916180 N3029HSmith Zachary · Nokesville, VABuilt 1978 · S/N 28-7911055 N3029LJenkins Jay P Jr · Amarillo, TXBuilt 1979 · S/N 32R-7987094 N3029WLong Stephen D · Ontario, ORBuilt 1979 · S/N 28R-7931128 N302AVRas Aviation LLC · Elyria, OHS/N 28-7716283 N302FGTactical Aviation LLC · Plymouth, MIBuilt 1980 · S/N 28-8016274 N302GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881458 N302MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010002 N302RTElston Josh Andrew · Deer Park, WABuilt 1982 · S/N 32R-8229039 N3030JJav Air LLC · Scottsdale, AZBuilt 1978 · S/N 32R-7987076 N3030MIn Line Aviation LLC · Greensburg, PABuilt 1977 · S/N 28R-7837109 N30314Tropic Breeze Leasing And Management LLC · Wilmington, DEBuilt 1978 · S/N 32R-7885085

Back to AD 87-08-08 R3