AD 87-10-06 R1

Registered aircraft · 72,010

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

N942CABaca Flavio Tomas · Vail, AZBuilt 1966 · S/N 28-3304N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116N942FLJochnma Steven J · Aumsville, ORBuilt 2001 · S/N 90042N942JFLuke James Michael · Austin, TXBuilt 2009 · S/N 90465N942LBWade Ronald · Lake Stevens, WABuilt 2010 · S/N 70801N942LCRegistered aircraftBuilt 2001 · S/N 3257265N942PTGarboden Patrick N · Katy, TXBuilt 2012 · S/N 90203N942RBJf Aviation LLC · Minot, NDBuilt 2005 · S/N T20608515N942TBillen Jarod H · Lakeland, TNBuilt 1960 · S/N TD-363N942TALost Squadron Inc · Wilmington, DEBuilt 1971 · S/N 11-11N942TBBailey Thomas R · Benton, KYBuilt 1963 · S/N 2587N942TECardinal Enterprise LLC · Jackson, WYBuilt 2003 · S/N 10221N942VTMcintosh Donald W · Sandpoint, IDBuilt 2010 · S/N 942N942WDHemdmm Corp · Wilmington, DEBuilt 1968 · S/N 31-333N9430NOakley Air LLC · Oakley, MIBuilt 1969 · S/N 28R-35142N9430PBonn Fred H · Jamestown, KYBuilt 1970 · S/N 24-4938N9430VRuff Deborah · Auburn, CABuilt 1970 · S/N 700030N9430W3zero Whiskey LLC · Newport Beach, CABuilt 1968 · S/N 28-11136N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411N9431JCurrie Kenneth Edward · Lumberton, NCBuilt 1966 · S/N 28-3542N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160N9433DPacer Flight LLC · Huron, OHBuilt 1958 · S/N 22-6407N9433EKozma Peter · San Diego, CABuilt 1979 · S/N 17272264N9433JSierra Delta Aviation Services Inc · Middletown, DEBuilt 1966 · S/N 28-3545N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556N9433WSanford William M · Olalla, WABuilt 1968 · S/N 28-11141N9434JSchmidt Matthew F · River Falls, WIBuilt 1966 · S/N 28-3546N9434PSheehan James A · Newberg, ORBuilt 1970 · S/N 24-4942N9434VKnackstedt Dennis R · Winfield, KSBuilt 1970 · S/N 700046N9434WJohnson James E · Calhoun, LAS/N VE-7711N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821N9435JHarmon Daniel J · Sheridan, INBuilt 1966 · S/N 28-3547N9435NDoran Jeffrey · Centerburg, OHS/N 28R-35148N9435PWahl John B · Pendleton, ORBuilt 1970 · S/N 24-4943N9435WPace Lawrence W · Westminster, COBuilt 1968 · S/N 28-11145N9436PWarren Michael W · Wiscasset, MES/N 24-4944N9436WGiesbrecht Harley L · Deridder, LABuilt 1968 · S/N 28-11153N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161N9437JGarba Ibrahim I · Boulder City, NVBuilt 1966 · S/N 28-3549N9438DWeidner Kevin G · Bunker Hill, ILBuilt 1958 · S/N 22-6412N9438HBering Capital LLC · Anchorage, AKS/N 17266155N9438PZimmerman Kyle R · Gilbert, AZBuilt 1970 · S/N 24-4946N9438VPrestridge Jacob · Portland, ORS/N 700071N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822N9439ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1979 · S/N 17272265N9439HTreichler Peter DBA · East Aurora, NYBuilt 1964 · S/N 6N9439KAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1976 · S/N 28-7625180N9439WCherokee Ltd LLC · Mesa, AZBuilt 1967 · S/N 28-11151N943GDowning John Brent · Castro Valley, CABuilt 2005 · S/N 30038CN943HSMonika Aviation LLC · Humble, TXBuilt 1978 · S/N 32R-7887062
Back to AD 87-10-06 R1