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.
N97MMRegistered aircraftN97MRRebel Back Home LLC · Waterford, MIN97MSJesnowski J Luke · Atchison, KSN97MVNorth American Safety Education Group LLC · Flowery Branch, GAN97MWRudderworks Aviation LLC · Fairfax Station, VAN97NNAviation Business Corp · Saint Louis, MON97NTChasteen Coleman C · Keller, TXN97PBlack River Construction Services LLC · Black River Falls, WIN97PFSoaring Eagles Flying Svc Ltd · Edwards, ILN97PLLarson Preston A · Webster, MNN97PZStoraasli Paul · Torrance, CAN97RADavis James K · Vero Beach, FLN97RKKeenan Michael P · Ankeny, IAN97RPCombs Jonathan R · Girdwood, AKN97RTDoran John F · Charlestown, RIN97RVLindberg Stephen J · Tumwater, WAN97RWWiplinger Robert D · Inver Grove Hts, MNN97SARegistration Pending · Peosta, IARegistration pendingN97SCIpme Management Corp · Jefferson, GAN97TFTerell Enterprises LLC · Deland, FLFirst renewal noticeN97TKDekalb Aviation LLC · Williston, NDN97UAManufacturing Services And Solutions LLC · Lake Villa, ILN97UPMf Helicopters LLC · East Troy, WIN97VPAtkins Louis Clifford Jr · Birmingham, ALN97WButler William E · Idaho Falls, IDN97WHCox Thomas R · Kirkland, WAN97WKPantas James S · Mount Pleasant, NCN97XCN97xc LLC · Milpitas, CAN97XTRobertson Paul L · Knoxville, TNN97XZAllen Nathanael W · Bemidji, MNN97ZZMx7 LLC · Hudson, OHN98001Goltsos William · Barrington, RIN98009Lebron Renard Luke Jr · Gulfport, MSN9800PGrisham Steve DBA · Belzoni, MSN9800UHarvey Mallory · Baxley, GAN9800WMrd Aero LLC · Manheim, PAN98012Registration Pending · West Sacramento, CARegistration pendingN98014Bas Part Sales LLC · Greeley, CON98015Rd Aire LLC · Opelika, ALN98017Blakeslee Vernon A Jr · Torrington, CTN9801WNorth Little Rock Air Inc · North Little Rock, ARN98021Wright Joseph R · Perry, GAN9802AAtp Aircraft 7 LLC · Wilmington, DEN9802UStoll John E · Summerville, SCN98037Hammer Joseph K · Dike, TXN9803CWhite Traci M · Manasquan, NJN9803DAttitude Aerobatics LLC · Wilmington, DEN9803PLosse Randall J · Wasola, MON9803YHubbard Nathan · Butte, MTN98041Rosman Patrick R · Creston, WA
Back to AD 87-10-06 R1