Skip to content

Registered aircraft · 40,472

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.

N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330HLSwift David A Trustee · Springfield, MOS/N 24941 N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152 N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033 N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444 N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210 N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154 N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161 N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320 N33147Johann Austin J · Richland Center, WIS/N 28-7525163 N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322 N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127 N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165 N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326 N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267 N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129 N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595 N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883 N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754 N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001 N331FBurton Charles E · Jackson, CABuilt 2001 · S/N 5703 N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277 N331GTPope Kent M · Hayden, IDBuilt 1984 · S/N 331 N331JBBostik Josef J · Green Cove Springs, FLBuilt 2002 · S/N 25108 N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464 N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477 N331NTCrowley E Ned · Londonderry, NHS/N N.C.1 N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514 N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720 N331VRRoof Jerry G · Centennial, COBuilt 1991 · S/N 509 N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543 N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401

Back to AD 80-04-03 R2