Skip to content

Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N330DGAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1991 · S/N 766 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330HLSwift David A Trustee · Springfield, MOS/N 24941 N330HPBigman Elliot S · Todd, NCS/N 01 N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267 N330JGCultra LLC · Naples, FLS/N 24-3042 N330KGBeats Driving LLC · Falling Waters, WVBuilt 2007 · S/N 40050 N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152 N330LSDawson Douglas · Fernley, NVBuilt 2000 · S/N 001 N330MCWoolever Shane M · Sault Sainte Marie, MIBuilt 1978 · S/N 32R-7987072 N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462 N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033 N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444 N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95 N330PCaldaso Inc · Peachtree City, GABuilt 1978 · S/N 32-7840164 N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210 N330RSSimeone Richard A · Rock Hill, SCBuilt 2021 · S/N 01 N330SMSa Aerosports LLC · Kalispell, MTBuilt 2004 · S/N 005 N330SXDb Aero Inc · Wilmington, DEBuilt 1995 · S/N JONAS-0007 N330TAAdvanced Aerobatics LLC · Ocala, FLBuilt 2002 · S/N 003 N330TFMartin Earl · Seneca Falls, NYBuilt 1996 · S/N 3246032 N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154 N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121 N3310WBig Wing Energy LLC · Decatur, ARBuilt 1965 · S/N 32-148 N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122 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 N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123 N33124Meyer Robert Dean Jr · California, MDBuilt 1975 · S/N 28-7510039 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124 N3312WMcmurray Michael J · Killeen, TXBuilt 1965 · S/N 32-150 N33133Balisier Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N 32-7540089 N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161 N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320 N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126 N33143Bascom Jon A Trustee · Tega Cay, SCBuilt 1975 · S/N 32-7500015 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 N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236 N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127 N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127 N33153Pathfinder Ff LLC · Dover, DES/N 28-7510040 N33155Don George LLC · Orlando, FLBuilt 1975 · S/N 32-7540090 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

Back to AD 87-10-06 R1