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.

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 N331AHArmstrong Helicopters LLC · Laredo, TXBuilt 2003 · S/N 10042 N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331BHBurks Aviation Inc · Hattiesburg, MSBuilt 1995 · S/N 06 N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754 N331DJMugford David Allen · Annapolis, MDBuilt 2007 · S/N 40331 N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001 N331ESJackson Paul D · Chesapeake, VAFirst renewal noticeBuilt 2001 · S/N 1067 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 N331JHStack Trevor J · Keller, TXBuilt 2005 · S/N 40142 N331JRLeclercq Benoit B · Saint Cloud, FLBuilt 1992 · S/N 5241 N331MDMedmission Supplies LLC · Escondido, CABuilt 2018 · S/N 90991 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 N331PEnglish Barton C · Liberty Corner, NJBuilt 2007 · S/N 40143 N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514 N331PHAppel Raymond Lee · Incline Village, NVBuilt 1977 · S/N 28-7710045 N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720 N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863 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 N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255 N3321LN3321l LLC · Dacula, GAS/N 3321 N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621 N3322GLone Star Flight Museum · Houston, TXBuilt 1970 · S/N 39-10 N3322KHamilton Roger A Trustee · Pisgah Forest, NCBuilt 1975 · S/N AA5B-0046 N3322WWilson Devin · Star, IDBuilt 1965 · S/N 32-156 N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296 N3323TDeese James K Jr · Charlotte, NCS/N 17700623 N3324WThompson Mark D · West Chicago, ILBuilt 1965 · S/N 32-158 N3325WGuzman Ronald Leonard · Salinas, CABuilt 1965 · S/N 32-160 N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111 N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277 N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626

Back to AD 87-10-06 R1