Skip to content

Registered aircraft · 2,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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N15684Carr Sean Michael-Noel · Prescott, AZBuilt 1972 · S/N 28R-7335081 N1569XStroud Jerry L · Hope, ARS/N 28R-7535331 N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086 N1574XQuinones Roland · Plano, TXS/N 28R-7535338 N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089 N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090 N15814Alderson Collin · North Bend, NEBuilt 1972 · S/N 28R-7335094 N1582XInnovative Aviation LLC · Indiana, PAS/N 28R-7535340 N15832Mickschl Bradley J · Avon, INBuilt 1972 · S/N 28R-7335093 N15862Butler Michael W · Sacramento, CABuilt 1972 · S/N 28R-7335098 N15894Dunlap Dalton · Port Neches, TXBuilt 1972 · S/N 28R-7335102 N158CCRegistration Pending · Visalia, CARegistration pendingBuilt 1977 · S/N 28R-7737081 N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104 N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344 N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106 N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108 N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345 N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291 N15MZCaillarec Philippe · Le RheuNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28R-7803274 N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121 N16293Quale Jeffrey L · Craig, COBuilt 1973 · S/N 28R-7335123 N16311Toxen Robert M · Fort Lauderdale, FLBuilt 1973 · S/N 28R-7335124 N16321Chamberlain Frederick L · Tavernier, FLBuilt 1973 · S/N 28R-7335126 N16329Greensite Phillip M · Walton, KYBuilt 1973 · S/N 28R-7335129 N16361Fly 361 LLC · Doswell, VABuilt 1973 · S/N 28R-7335134 N16362Flightline Air Service LLC · Pineville, LABuilt 1973 · S/N 28R-7335135 N16368Tougas William E · Timberlake, NCBuilt 1973 · S/N 28R-7335136 N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141 N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145 N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112 N16437Novawings Aviation LLC · Porter, TXS/N 28R-7335146 N16459Chase Charles D · Baskin, LABuilt 1973 · S/N 28R-7335150 N16530Beldon Concrete LLC · Liberty, KYBuilt 1973 · S/N 28R-7335158 N16531Bethge Wade K · Paxinos, PABuilt 1973 · S/N 28R-7335159 N16554Sk Group LLC · Moore, SCBuilt 1973 · S/N 28R-7335162 N16555Vampola Timothy D · Bellevue, NEBuilt 1973 · S/N 28R-7335163 N16566Schaumberg John · Lebanon, INS/N 28R-7335164 N165LHRochester Air Center LLC · Canandaigua, NYBuilt 2011 · S/N 2844144 N1663HSecure Uicc Corp · Glen Burnie, MDS/N 28R-7737007 N1671HBarth Samuel · Fonda, NYS/N 28R-7737008 N1680HShimkus Aviation LLC · Tupelo, MSS/N 28R-7703031 N1691HButterfield Arthur W Jr · Holland, MIS/N 28R-7703032 N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150 N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262 N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057 N16JSMace Terry G · Saint James, MNBuilt 1973 · S/N 28R-7335304 N1705MYeager Jacob M · Ignacio, COBuilt 1975 · S/N 28R-7535260 N1707HCyberflight Inc · Wilmington, DEBuilt 1977 · S/N 28R-7737010 N172NDBlue Max Aero LLC · Miles City, MTBuilt 1988 · S/N 2837007 N1746H1746h LLC · La Mirada, CAS/N 28R-7737011

Back to AD 82-06-11 R1