Skip to content

Registered aircraft · 5,102

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:81-12-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:81-12-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:81-12-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:81-12-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:81-12-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:81-12-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.

N4056WHighwing Flyers Inc · Cape May Ch, NJBuilt 1966 · S/N 32-40081 N40571Bwh Leasing LLC · Lewes, DEBuilt 1974 · S/N 27-7405313 N40578Dna Flight Ops LLC · Edgewater, FLBuilt 1974 · S/N 27-7405322 N4057RCurrier Dustan · Fairbanks, AKBuilt 1967 · S/N 32-40361 N4057W57whiskey LLC · Rowlett, TXBuilt 1966 · S/N 32-40083 N40581Chagres Aero LLC · Albuquerque, NMBuilt 1974 · S/N 27-7405325 N4058RSanders Christopher A · Escondido, CABuilt 1967 · S/N 32-40363 N4058WBrandon Sidney J III · Dundas, VABuilt 1966 · S/N 32-40085 N40599Tcb Aviation Inc · Knoxville, TNBuilt 1974 · S/N 27-7405345 N405CGPinheiro Rodrigo Postal · Albuquerque, NMBuilt 1994 · S/N 27-0179 N405WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640043 N4060BSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 75-31110 N4061RHorse Saddle Shop Inc · Bremen, INBuilt 1967 · S/N 32-40369 N4064RHissem John T · Castle Rock, COBuilt 1967 · S/N 32-40372 N4065RDever Brandon · Auburn, CABuilt 1967 · S/N 32-40373 N4065WGrubs Jon P · Winter Haven, FLBuilt 1967 · S/N 32-40099 N4066RMoore Arthur Douglas · Sulphur Springs, TXBuilt 1967 · S/N 32-40374 N4067RM & H Aviation LLC · Homestead, FLBuilt 1967 · S/N 32-40375 N4067WBluestone Land LLC · Charlottesville, VABuilt 1966 · S/N 32-40103 N40698Murphy Robert H · Skagway, AKBuilt 1973 · S/N 32-7440056 N4069WRoss Christian M · Bakersfield, CABuilt 1966 · S/N 32-40107 N406DZSpeedstar Aviation LLC · Kalispell, MTBuilt 1978 · S/N 31-7812051 N406LBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208406 N406WBNew England Airlines Inc · Westerly, RIBuilt 1975 · S/N 32-7640058 N4070RBamfs Group LLC · Davie, FLBuilt 1967 · S/N 32-40380 N4071RHansen Lindsay Tucker · Las Vegas, NVBuilt 1968 · S/N 32-40381 N4072LN4072l LLC · Conroe, TXBuilt 1980 · S/N 31-8152019 N4072WBradford Alan R Jr · Ridgecrest, CABuilt 1966 · S/N 32-40113 N4073LColumbia Asset Trust Corp Trustee · Wichita, KSS/N 31-8152029 N4073RLibby Stephen E · Lincoln, MEBuilt 1967 · S/N 32-40384 N40747Cherokee Flyers LLC · Austin, TXS/N 32-7440058 N4074WYork Leslie Neal · Johnstown, COS/N H-13 N4075RCoastal Airways LLC · Dover, DEBuilt 1968 · S/N 32-40387 N4076RTwk Air LLC · Morgantown, PABuilt 1968 · S/N 32-40389 N4076TMike Jones Aircraft Sales Inc · Murfreesboro, TNBuilt 1980 · S/N 31-8152046 N4077RMccollum Aviation Inc · Friendswood, TXS/N 32-40390 N4077WMontgomery Charles · Tupelo, MSBuilt 1980 · S/N 31-8112031 N40784High Flying Club Inc · Fort Wayne, INBuilt 1973 · S/N 32-7440060 N4078BDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 31-8152055 N4078JStar Marianas Air Inc · Tinian, MPBuilt 1980 · S/N 31-8152057 N4078RBrehmer Family Airplane LLC · Knoxville, TNBuilt 1967 · S/N 32-40392 N4079HWarbelow'S Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152074 N4080BIbrahim Phillip · Whitinsville, MABuilt 1974 · S/N 75-32-150 N4080WLance & Company LLC-S · Uniondale, INBuilt 1966 · S/N 32-40125 N40813Hendrix Charles W · Boca Raton, FLBuilt 1981 · S/N 31-8112040 N4081BCooley George · Cedar Rapids, IABuilt 1975 · S/N 75-32-161 N4082TWarbelows Air Ventures Inc · Fairbanks, AKBuilt 1981 · S/N 31-8152089 N4083W13 Aviation LLC · Leesburg, GABuilt 1981 · S/N 31-8152099 N4084RLand Aerial Services LLC · Conway, ARBuilt 1967 · S/N 32-40401 N4085RWojdac David E · Mosinee, WIS/N 32-40402

Back to AD 81-12-06 R1