Skip to content

Registered aircraft · 56,580

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-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N363BLElizabeth City State University · Elizabeth City, NCBuilt 2004 · S/N 172S9741 N363CKAviator Air Operations LLC · Grand Prairie, TXBuilt 2004 · S/N 172S9634 N363CPBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 172S8382 N363CS3tr Aviation LLC · Longview, TXBuilt 2022 · S/N 18283163 N363JVRead Andrew R · Milwaukee, WIBuilt 1976 · S/N 18502991 N363KRegistered aircraftBuilt 2018 · S/N 172S12195 N363MAMuchodeanaero Inc · Wilmington, DEBuilt 1998 · S/N 172S8006 N363SAN363sa LLC · Stuart, FLS/N 17280756 N363SPOrange County Flight Center Inc · Santa Ana, CABuilt 2001 · S/N 172S8781 N364Farmers Bank · Parsons, TNBuilt 1976 · S/N P3370243 N3640JCovington Brian · Florence, ALBuilt 1966 · S/N 15064940 N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809 N3640SPetersen Jacob R · Wasilla, AKS/N 17250840 N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040 N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810 N3641VWright John C · Windham, MEBuilt 1975 · S/N 15076573 N3642CMcmahan Bryan · Gakona, AKBuilt 1954 · S/N 31140 N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811 N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042 N3643BCoffelt Kelly L · Bend, ORBuilt 1956 · S/N 32347 N3643CThompson Thomas S · Stoutsville, OHS/N 31141 N3643SMaycroft David · Cary, ILBuilt 1963 · S/N 17250843 N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043 N3644JBoggs Dilan · Nicholls, GABuilt 1966 · S/N 15064944 N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813 N3644SMurray William · East Jordan, MIBuilt 1963 · S/N 17250844 N3644TArizona Air Salvage · Phoenix, AZS/N 17260849 N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044 N3645LRegistered aircraftBuilt 1965 · S/N 17253814 N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045 N3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationBuilt 1966 · S/N 15064946 N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815 N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827 N3646UGarner Lynn · Preston, IDS/N 18255046 N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146 N3647CSmith Kristopher D · Wickenburg, AZBuilt 1954 · S/N 31145 N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816 N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047 N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817 N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048 N3649CBayou Flight LLC · Parker, COBuilt 1954 · S/N 31147 N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818 N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049 N364CMoore Charles K · Woodinville, WABuilt 1978 · S/N 18266262 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8803 N364DRegistered aircraftBuilt 2014 · S/N 172S11373 N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N364GWHdh Aircraft Leasing LLC · Carrollton, TXBuilt 2003 · S/N 172S9364 N364MAJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8007

Back to AD 79-10-14 R1