Skip to content

Registered aircraft · 1,752

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-11-02-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-11-02-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-11-02-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-11-02-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-11-02-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-11-02-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.

N15523Derryberry Clay · Lewisburg, TNBuilt 1972 · S/N 28R-7335065 N15524Brown Gerald · Apple Valley, MNBuilt 1972 · S/N 28R-7335066 N15545Ungaro James P Sr · Las Vegas, NVBuilt 1972 · S/N 28R-7335068 N1554XBertagna LLC · Chico, CABuilt 1975 · S/N 28R-7535324 N15562Hulihan Tom · Eerie, COBuilt 1972 · S/N 28R-7335070 N15597Watson Keith A · Sale Creek, TNBuilt 1972 · S/N 28R-7335072 N15600Curry Dwain · Apopka, FLBuilt 1972 · S/N 28R-7335073 N15623Terrill Wallace · Otis, MABuilt 1972 · S/N 28R-7335075 N1562XLaliberte Christopher M · Ridgecrest, CABuilt 1975 · S/N 28R-7535326 N15633Jime Aero LLC · Ontario, CABuilt 1972 · S/N 28R-7335076 N15643Aerolease Ltd · Dubuque, IABuilt 1972 · S/N 28R-7335088 N15644Meriden Aviation Center LLC · Meriden, CTBuilt 1972 · S/N 28R-7335077 N15665Burns Dana W · Pataskala, OHS/N 28R-7335079 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 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

Back to AD 81-11-02 R1