Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411 N5351QBarrett Dannie P · Halfway, ORS/N 17261778 N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655 N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413 N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096 N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078 N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416 N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776 N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777 N5354DGonzalez Alejandro B · El Paso, TXBuilt 1979 · S/N 17272540 N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160 N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658 N5356DDethlefs Robert L · Clackamas, ORBuilt 1979 · S/N 17272541 N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107 N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659 N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164 N5356WMahler Alex · Fayetteville, ARBuilt 1962 · S/N 28-420 N5356XSkywest Leasing Inc · St George, UTS/N 2843521 N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528 N53571George Michael F · Ferndale, WABuilt 1981 · S/N 17274781 N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537 N5357EHoffman Dennis M · Winchester, VABuilt 1978 · S/N 17271840 N5357JArizona Bravo Lima LLC · Phoenix, AZBuilt 1980 · S/N 17273762 N5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421 N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391 N53588Davis Charles · Sanford, FLBuilt 1981 · S/N 17274782 N5358DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272543 N5358LTwidwell Jon J · Olathe, KSS/N 28-4661 N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306 N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098 N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663 N53600Kdrd Holdings LLC · Texas City, TXS/N 17272544 N53603Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17274786 N5360JFly Montana LLC · Miles City, MTBuilt 1980 · S/N 17273763 N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664 N5360WShaffer Thomas D · Round Rock, TXS/N 28-425 N53611Aero Mobil Inc · Wilmington, DEBuilt 1981 · S/N 17274787 N5361KLong Island Soaring Association · Shirley, NYBuilt 1980 · S/N 17274080 N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549 N5361WRoberts Misty L · Fountain Hills, AZBuilt 1962 · S/N 28-426 N53622Mc Air LLC · Miami Beach, FLBuilt 1981 · S/N 17274788 N5362HMccue Tedd R · Eveleth, MNBuilt 1975 · S/N 17265412 N5362LTiedemann Douglas A · Skaneateles, NYBuilt 1968 · S/N 28-4667 N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555 N5362XSky West Aviation Inc Trustee · Albuquerque, NMS/N 18-6685 N53630Arlington Flight Services Inc · Arlington, WABuilt 1981 · S/N 17274789 N53632Siple Aviation LLC · Kalispell, MTS/N 17274791 N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559 N5363KMission Aviation Training Academy · Arlington, WABuilt 1980 · S/N 17274081 N5363LTeehee Max L · Searcy, ARBuilt 1968 · S/N 28-4668

Back to AD 80-04-03 R2