Skip to content

Registered aircraft · 68,375

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N28146Young James W · Talking Rock, GABuilt 1940 · S/N 4611 N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182 N2814PSargent Wayne M · Bremerton, WABuilt 2002 · S/N WS1 N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807 N28151Stewart Thomas · Churchville, NYBuilt 1940 · S/N 5-119 N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728 N2815FKlopping William E · Apple Valley, CAS/N 28-7916438 N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108 N2815TNorwest Ventures LLC · Sagle, IDBuilt 1978 · S/N 15282250 N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78 N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451 N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452 N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297 N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216 N28170Stracar Miro · Syosset, NYBuilt 1991 · S/N 1157 N2817BNew Air Inc · Pocahontas, IABuilt 1956 · S/N 1500 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 N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704 N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334 N2818GRenda Joseph · Dunnellon, FLBuilt 1967 · S/N 515 N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462 N2818PHancock Timothy R · Malinta, OHBuilt 1955 · S/N 22-3111 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 N2818ZJohnston Charles W C · Newfield, NJS/N 22-6811 N28199Guppy Aviation LLC · New Smyrna Beach, FLBuilt 1990 · S/N 1062 N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469 N2819FMacair LLC · Kennesaw, GABuilt 1979 · S/N 28R-7918156 N2819LMason Timothy F · Effingham, ILS/N 1116 N2819MDzr Enterprises LLC · Missoula, MTBuilt 1946 · S/N 12-1174 N2819PRector David F · Akron, OHBuilt 1955 · S/N 22-3112 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227 N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219 N281BAnderson David R · Sycamore, ILBuilt 1959 · S/N 140 N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280 N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665 N281CAppel Daniel E · Redfield, SDBuilt 1999 · S/N 1456 N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111 N281CTCutcher John M · Annapolis, MDBuilt 2008 · S/N 71082 N281DMBalducki James B · Signal Hill, CABuilt 1999 · S/N 1258-99 N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323 N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130 N281PCBlair Bobby G · Essex, MOBuilt 2003 · S/N 1342-2003 N281RABluewater Airmotive Corp · Wilmington, DEBuilt 1976 · S/N 28-7615352 N281TWSkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881091

Back to AD 90-04-06 R1