Skip to content

Registered aircraft · 4,001

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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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.

N758CEKleiss Roderick E · Grantsburg, WIBuilt 1978 · S/N R1722982 N758CFClementi Peter · Miami, FLBuilt 1978 · S/N R1722983 N758CM172 Flyers Group LLC · Phoenix, AZBuilt 1978 · S/N R1722989 N758CQKissinger Richard Gordon · Centre Hall, PABuilt 1978 · S/N R1722992 N758CSGulf Coast Helicopters Inc · Pearland, TXBuilt 1978 · S/N R1722994 N758CWMidland College Flying Club · Midland, TXBuilt 1978 · S/N R1722998 N758DECenturion Aviation LLC · Salina, KSBuilt 1978 · S/N R1723006 N758DG89u LLC · Columbia, MOBuilt 1978 · S/N R1723008 N758DHQuy Matthew · Rosemount, MNBuilt 1978 · S/N R1723009 N758DPSwanson Eric David · Louisville, KYBuilt 1978 · S/N R1723015 N758DQPaul Dotterer & Sons Inc · Mill Hall, PABuilt 1978 · S/N R1723016 N758DRSavage Terry M · Brentwood, NHBuilt 1978 · S/N R1723017 N758DTCurry Brian · Elk Point, SDBuilt 1978 · S/N R1723019 N758DVHooey David L · Duluth, MNBuilt 1978 · S/N R1723021 N758DWFire House Aviation LLC · Nantucket, MAS/N R1723022 N758DZStevenson Daniel Richard · Jonesboro, ARBuilt 1978 · S/N R1723025 N758EEDistant Island Ventures LLC · Beaufort, SCBuilt 1978 · S/N R1723030 N758EGPayne James Melvin · Flushing, MIBuilt 1978 · S/N R1723032 N758EJJrnd Corp · Lewes, DEBuilt 1978 · S/N R1723034 N758EMKiroy Bradley R · Plattsburgh, NYBuilt 1978 · S/N R1723037 N758ENFrey Kenneth H · Corfu, NYS/N R1723038 N758ESVidal Aviation LLC · Gaithersburg, MDBuilt 1978 · S/N R1723042 N758EYMccutcheon Mark E · Friday Harbor, WABuilt 1978 · S/N R1723048 N758FAArctic Aviation LLC · Farmington, MNBuilt 1978 · S/N R1723050 N758FBCat Iiic Aviation LLC · Erie, PAS/N R1723051 N758FDGrosch Drilling Enterprises Inc · Dublin, GABuilt 1978 · S/N R1723053 N758FEHeddy George E III · Hendersonville, NCBuilt 1978 · S/N R1723054 N758FFStockhoff LLC · Califon, NJS/N R1723055 N758FHSurprenant Charles E · Saint Albans, MEBuilt 1978 · S/N R1723057 N758FKOboyle T W · Seattle, WABuilt 1978 · S/N R1723059 N758FMBradley Richard · Los Angeles, CABuilt 1978 · S/N R1723061 N758FRTrigger Aviation LLC · Monument, COBuilt 1978 · S/N R1723065 N758FUAviation Trust Co LLC Trustee · Oklahoma City, OKS/N R1723068 N758FV758 Flyers LLC · Longmont, COBuilt 1978 · S/N R1723069 N758FWLarsen Don A · Kenosha, WIBuilt 1978 · S/N R1723070 N758FZWright Base Flight Training LLC · Tullahoma, TNBuilt 1978 · S/N R1723073 N758GBDaystar Aviation LLC · Eugene, ORBuilt 1978 · S/N R1723075 N758GCAndrews Ralph M · Jacksonville, FLBuilt 1978 · S/N R1723076 N758GFInflyt LLC · Carlsbad, CABuilt 1979 · S/N R1723079 N758HARegistration Pending · Jacksonville, ARRegistration pendingS/N R1723098 N758HCCentral Air Parts Inc · Staunton, ILBuilt 1979 · S/N R1723100 N758HKAir Pierre LLC · Orlando, FLBuilt 1979 · S/N R1723107 N758HLCunningham Robert F · Gibraltar, MIBuilt 1979 · S/N R1723108 N758HMBwg Hanger LLC · Los Angeles, CABuilt 1979 · S/N R1723109 N758HSEdge Of The World Inc · Banner Elk, NCBuilt 1979 · S/N R1723114 N758HTStinnett Raymond C · Bozeman, MTBuilt 1979 · S/N R1723115 N758HVLozoya Luis G · Yuma, AZBuilt 1979 · S/N R1723117 N758JBYuen Kin Chun · Elk Grove, CABuilt 1979 · S/N R1723123 N758JDHancock Gregory C · Eastsound, WABuilt 1979 · S/N R1723125 N758JGMorton Frank W · Harwinton, CTBuilt 1979 · S/N R1723128

Back to AD 81-13-10 R1