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.

N336SGAndrade South Florida Services Inc · Plantation, FLS/N 1336 N336VRobertson Ryan T · Richmond, VABuilt 1979 · S/N 79-31155 N3370WRaddohl Garret L · New London, MNS/N 32-216 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N3372MFarah Michael J · Mclean, VABuilt 1980 · S/N 28-8011059 N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028 N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245 N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184 N33735Mcenaney John E · Orlando, FLBuilt 1975 · S/N 28-7510058 N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374WMcfadyen Joseph P · Florence, SCS/N 32-220 N3374XLee Rollin Kim · Panaca, NVS/N 1091 N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249 N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187 N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360 N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176 N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188 N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235 N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361 N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178 N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380 N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191 N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3377XPenalo Garcia William J · Toa Baja, PRBuilt 1966 · S/N 1092 N3377ZMorris David S · North Pole, AKBuilt 1960 · S/N 18-7258 N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277 N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524 N3378WKimball Jason S · Riverview, FLS/N 32-232 N3378XBurdis W J · Beaver Falls, PABuilt 1966 · S/N 1093 N33793Schwartz Robert E · Middleburg, FLBuilt 1975 · S/N 28-7515363 N33795Coco Phillip J · Middletown, CTBuilt 1975 · S/N 28R-7535194 N33796235 Flying Circus Inc · Gillette, NJBuilt 1975 · S/N 28-7510063 N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459 N337BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881099 N337BMSky Drivers LLC · La Fayette, GABuilt 1999 · S/N 18280629 N337CRElder Bruce W · Farmington, NMBuilt 2004 · S/N T18208259 N337CWWebb Peter C · Rockport, MEBuilt 2010 · S/N 90811 N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027 N337DCRichards Douglas A · Cookeville, TNBuilt 1978 · S/N F33700086 N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064 N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550

Back to AD 87-10-06 R1