Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

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 N40865Fischer William T · Ventura, CABuilt 1973 · S/N 32-7440066 N4086EJj Aviation LLC · Allentown, PABuilt 1981 · S/N 31-8152114 N4086WMorgan Gabriel A Sr · Newport News, VABuilt 1967 · S/N 32-40137 N4087KAggie Air Inc · Clifton, TXBuilt 1981 · S/N 31-8152129 N4087RWatt Nathan A · Walnut Creek, CABuilt 1967 · S/N 32-40405 N4088BClinic Air Aviation Inc · Chapmansboro, TNBuilt 1975 · S/N 75-31120 N4088RKako Retreat Center Inc · Russian Mission, AKS/N 32-40407 N408WBNew England Airlines · Westerly, RIBuilt 1972 · S/N 32-7240092 N4090BHaun Trevor · Placerville, CABuilt 1975 · S/N 75-31112 N4090RWiebe Aerial Applications LLC · Peabody, KSBuilt 1967 · S/N 32-40410 N4090UIsland Bound LLC · Dunedin, FLS/N 31-8152147 N40913Matlock Joshua · Squaw Valley, CABuilt 1975 · S/N 32-7540126 N40919Asb1 Group LLC · Miramar, FLS/N 31-8152162

Back to AD 91-21-01 R1