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.
N68BWRegistered aircraftN68CAAsset Management Advisors Corp · Plantation, FLN68CNEichten Steve G · Colleyville, TXN68CSTrojen Properties LLC · Joplin, MON68DSkaggs Randall D · Sacramento, CAN68DBLai LLC · Flowood, MSN68DEMazzoni Dennis · Mays Landing, NJN68DGDellar Randy Roger · Wasilla, AKN68DSSichak Stephen Jr · Wanaque, NJN68DWAero Group I LLC · Woodstock, VAN68EEBurtt John B · Pierson, MIN68FSistrunk Donald M · Ragley, LAN68FDVargas Emmanuel N · Murrieta, CAN68GJDc Foote & Associates Inc · Camarillo, CAN68HKPomeroy Andy Lee · Seattle, WAN68JBOtto Pilot LLC · Everett, WAN68JCCapps Jon T · Bentonville, ARN68JDCorman Justin W · Bridgeport, NEN68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingN68JTVallandi Amy E · Las Vegas, NVN68JXRybarczyk Thomas B · Benton, KSN68JYHowell Jon · Texarkana, ARN68KSeymour Robin · Woodland Hills, CAN68KBKeller Bros Airport Inc · Lebanon, PAN68KTHobein Ted · Wheaton, ILN68LCDriver Matthew · Rio Rancho, NMN68LHGottschall James W · Highland, WIN68LKKing Larry E Jr · Wenatchee, WAN68LRMs Aero Inc · Lakeville, OHN68MABig Creek Flyers LLC · Lewes, DEN68MCAlpha Enterprises · Burley, IDN68MWCsc Delaware Trust Co Trustee · Wilmington, DEN68NDSand Nicholas Patrick · Alta, IAN68QCobb Lee C · Van Alstyne, TXN68RLeroy Philippe G · Willcox, AZN68RLSlutz David E · Morristown, TNN68RSAlston Walter III · Fernandina Beach, FLN68RVSteed David A · Oklahoma City, OKN68SBLucey William E · Salisbury, NCN68SCBridges Lee P · Smithville, TNN68SDPro Aero LLC · Warrenton, VAN68SEGateway Flight Center LLC · Port Lavaca, TXN68TSSmith Timothy R · Victoria, TXN68TYKing Ty · Rogers, ARN68VCammack Daniel P · Colorado Springs, CON68VEK F Aviation Inc · San Juan, PRN68VRGene Coleman Machine Inc · Menominee, MIN68WLGlobal Pilot Inc · Wilmington, DEN68WPButseev Anthony · Tarzana, CAN68WWGalloway Lyle R · Ashton, ID
Back to AD 87-10-06 R1