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.
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.
N8797WBenson Marvin D · Bertrand, NEN8797YHight Derrick R · North Aurora, ILN8798EFuller Glenn C · Santa Paula, CAN8798VPalmer Harvey F · Omaha, NEN8798WGregory Cody A · Lamar, MON8799DStadman Tyrel W · Eagle River, AKN8799FNew England Equip Corp · Auburn, MARevoked, canceledN8799NDuffe William B · Moscow, IAN8799PMontgomery M Kim · Vega, TXN8799WFeller Gerald · Long Beach, CAN879CBFerris Robert C · Port Washington, NYN879GHollander Ronald Stefan · Woodmere, NYN879MPTriple K & F Flying LLC · Greenwood, MSN879RVNajarian Stephen N · Boulder, CON879SCCogswell Steve L · Corona, CAN879SPGlick Emanuel S Jr · Morgantown, PAN879WHHumphrey Ronald D · Pace, FLN87AJdkracl Aircraft LLC · Gretna, NEN87AEHayes Travis · Harrisonville, MON87AFMetcalf Shane L · Wasilla, AKN87AVYoung Randy K · Wichita Falls, TXN87BRDredge Forward Corp · Melbourne, FLN87CTWoodard Rodney W · Brighton, CON87CWZou Christian · Chandler, AZN87CZScotese Attilio G · Mammoth Lakes, CAN87DLBristol David F · Torrance, CAN87ETTropper Edward J · Erie, PAN87FFFf22 LLC · Scottsdale, AZN87FTR & L Air Service LLC · Wilmington, DEN87GBertacchi Lawrence · Vineland, NJN87GGVaughn Aviation LLC · Brandon, MSN87GLPendleton Terry S · Salisbury, NCN87GTWhiskey Tango Foxtrot24 LLC · Kalispell, MTN87GZGonzalez Jorge L · Pensacola, FLN87HFHeritage Asset Leasing LLC · Ronkonkoma, NYN87HPConnolly Andrew Leadley · Seabrook, TXN87HYDuke Ray J · Texico, NMN87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILN87KCAviation 3 D Loggers LLC · Sheridan, WYN87KGCherokee From Sebring LLC · North Brunswick, NJN87LJRegistration Pending · Chicago, ILRegistration pendingN87MSellers Mark · Philadelphia, PAN87MBTraining Planes LLC · Tampa, FLN87MCNorthern Blue Skies Inc · Shawano, WIN87MRReisdorfer Mark J · La Follette, TNN87MXHalbritter Shawn M · Caldwell, IDN87NHEberling Ernest W · Central Point, ORN87NMChildress Gregory F · Dallas, TXN87PCraig Stephen J Trustee · Lawrence, KSN87PDRyan Patrick W · Poway, CA
Back to AD 87-10-06 R1