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.

N42KANorth Little Rock Air Inc · North Little Rock, ARBuilt 1966 · S/N 28-3702 N42KRDonnelly Charles A · Browns Mills, NJBuilt 1977 · S/N 28-7716295 N42PGWright Charles E · Hebron, KYBuilt 1977 · S/N 28R-7703353 N42RGInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7985071 N42RTMonette Michael · Dallas, TXBuilt 1983 · S/N 32R-8329030 N42SPCw Air LLC · Broken Bow, NEBuilt 1974 · S/N 28-7415437 N43004Griffin Robert L · Washington, NCS/N 28R-8331033 N4300SLcc West LLC · Freehold, NJS/N 28-8316064 N4300TPei-Ning Lo · Rowland Heights, CABuilt 1971 · S/N 28-7225128 N4300UUltimate Thermal Inc · Omaha, NES/N 28-8390053 N4300VMoe Jeffery Allen Jr · Tioga, NDBuilt 1983 · S/N 28-8311016 N43014Woodworth Neal A · Geneva, OHBuilt 1974 · S/N 28R-7435241 N43017Conn Farms Inc · Jeffersonville, OHBuilt 1974 · S/N 28-7415408 N4301FNewberg Curtis · Willmar, MNBuilt 1976 · S/N 32R-7680433 N4301JHarris Matthew P · Batavia, NYBuilt 1967 · S/N 28-22671 N4301LMckelvey Colt A · Canonsburg, PABuilt 1969 · S/N 28-11332 N4301MHayes Feeding Company LLC · Osceola, NEBuilt 1983 · S/N 32-8306017 N4301NStoddard Don · Great Falls, MTS/N 32R-8329025 N4301XDestination 55 LLC · Cave Springs, ARBuilt 1975 · S/N 28-7625008 N43020Blue Skies Flying Services Inc · Lake In The Hills, ILBuilt 1974 · S/N 28-7415409 N43023Drs Sandra M Krokos And Thomas P Kislan Pc · Hazle Township, PABuilt 1974 · S/N 28-7415410 N4302KMmwbc LLC · Hamilton, MTS/N 32-8324011 N4302TRiley Thomas J · West Grove, PABuilt 1983 · S/N 28-8316065 N4302XJin Jin Aviation LLC · Anchorage, AKBuilt 1975 · S/N 28R-7635005 N43037Miloud Chadd K · Fort Worth, TXBuilt 1983 · S/N 28-8316068 N4303FDdt Flyers LLC · Lynchburg, VAS/N 28-8311017 N4303JGroff Paul F · San Leandro, CABuilt 1967 · S/N 28-22674 N4303PBenham Properties LLC · Sullivan, INS/N 32R-8313020 N4303TReem Steven J · Cogan Station, PABuilt 1971 · S/N 28-7225129 N43044Will Eric S · Waseca, MNBuilt 1974 · S/N 28-7405170 N4304DPops Aviation LLC · Pace, FLS/N 28-8316070 N4304JStetser Nicholas R · Redding, CAS/N 28-22675 N4304LExplorer Sky Ventures LLC · Newark, DEBuilt 1983 · S/N 32R-8329027 N4304TButler Jeffrey C · Abilene, TXBuilt 1971 · S/N 28-7225131 N4304WGuyton Gregory P · Phoenix, MDBuilt 1983 · S/N 32-8306029 N43050Essex Air LLC · Franklin Lakes, NJBuilt 1974 · S/N 28-7415415 N43051Luitjens Jacob J · Cascade Locks, ORBuilt 1974 · S/N 28-7415416 N43055Plain Plane Partners LLC · Wilmington, DEBuilt 1983 · S/N 28-8390066 N43056Lucier Laura M · Houston, TXBuilt 1983 · S/N 28-8390067 N43057Bogaard Family Partnership · Park Rapids, MNBuilt 1974 · S/N 28-7415418 N4305JThompson Judith P · Loleta, CABuilt 1967 · S/N 28-22676 N4305NBrellenthin Robert S · Roseau, MNBuilt 1983 · S/N 28-8311020 N4305XKrzykwa Thomas F · Newark, DEBuilt 1975 · S/N 28-7625009 N43060Jefferson City Aviation Inc · Jefferson City, MOBuilt 1983 · S/N 28-8316074 N43062Burgraff William B · Palatine, ILBuilt 1974 · S/N 28R-7435245 N4306BPv Rec Flight LLC · West Chester, PABuilt 1983 · S/N 28-8390068 N4306FN4306f Inc · Winter Haven, FLBuilt 1976 · S/N 32R-7680434 N4306TKaszynski John · Porter Ranch, CABuilt 1971 · S/N 28R-7235004 N4306VArchwell Aviation LLC · Glendale, AZS/N 32R-8329028 N43070Wkb Aviation LLC · Walnut Creek, CABuilt 1974 · S/N 32-7440115

Back to AD 87-08-08 R3