Skip to content

Registered aircraft · 40,396

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N46423Parrish Aviation Flight Academy LLC · Southlake, TXS/N 17257259 N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396 N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78 N4642WHash Marshall W · Crumpler, NCS/N 13172 N46430J & Dk LLC · Overland Park, KSBuilt 1968 · S/N 17257263 N46433Plummer Fred C · Normal, ILBuilt 1968 · S/N 17257264 N46435Hawkins County Sports Wings Inc · Kingsport, TNBuilt 1968 · S/N 17257266 N46436Aero Science International LLC · Martinez, GABuilt 1968 · S/N 17257267 N46437Arizona Active Air LLC · Yuma, AZBuilt 1968 · S/N 17257268 N46440Engelskirger Karl D · Valley City, OHS/N 17257270 N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272 N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276 N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277 N4644JWinslow Francis E III · Raleigh, NCS/N 17273659 N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78 N4644YState Of Montana · Helena, MTBuilt 1971 · S/N 18-8945 N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281 N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399 N4646Bailey Christopher J · Riga, MIBuilt 1975 · S/N M-II-480 N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283 N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285 N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400 N4646VBaran Stephen · Littlestown, PABuilt 1978 · S/N VAC-100-78 N46470Registration Pending · St Charles, ILRegistration pendingBuilt 1968 · S/N 17257291 N46484Campisteguy Alexander J · Renton, WABuilt 1968 · S/N 17257298 N46486Calimesa LLC · North Las Vegas, NVBuilt 1968 · S/N 17257300 N4648MKaye Mykle · Wailuku, HIBuilt 1949 · S/N 14-495 N46493Brown Michael F · Richford, NYBuilt 1974 · S/N 17264186 N46495Hanna Douglas L · Winchester, KYBuilt 1968 · S/N 17257306 N46497Tones Trucking Inc · Cassopolis, MIBuilt 1968 · S/N 17257307 N4649QSkyhawk Services LLC · Lake Wales, FLBuilt 1973 · S/N 17261735 N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404 N464DBCloud James G · Camden, MEBuilt 1973 · S/N 17262328 N464HSMcwaters Herbert L · Scottsdale, AZBuilt 2004 · S/N 25688 N464MSSchulze Michael F · Lees Summit, MOBuilt 2004 · S/N 1 N464SAerotrans Management LLC · Mercer Island, WABuilt 2003 · S/N 5495 N4650CLittle Jon R · Anchorage, AKBuilt 1953 · S/N 25594 N4650DSuperior Aviation Gateway LLC · Tampa, FLBuilt 1979 · S/N 17272324 N46510Persyk Dennis E · Hampshire, ILBuilt 1968 · S/N 17257314 N46511Connecticut Valley Flyers Inc · Glastonbury, CTBuilt 1969 · S/N 17257315 N46512Central Oklahoma Aviators Flying Club · Piedmont, OKBuilt 1968 · S/N 17257316 N46514Melander Aaron G · Denver, COBuilt 1968 · S/N 17257317 N46518Adventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1968 · S/N 17257319 N46519Northern Pilots LLC · Bozeman, MTBuilt 1968 · S/N 17257320 N4651DMcwilliams Robert G · Irving, TXBuilt 1979 · S/N 17272325 N4651GAviation Sky Art LLC · Anacortes, WABuilt 1979 · S/N 17273277 N46521Shadow Yacht LLC · Reno, NVBuilt 1968 · S/N 17257322 N46525Yarnall Paul J · Canandaigua, NYBuilt 1968 · S/N 17257326 N46526Bluebird Aviation LLC · Arrington, TNBuilt 1968 · S/N 17257327 N46529Toledo City School District · Toledo, OHBuilt 1968 · S/N 17257329

Back to AD 79-10-03 R2