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.
N9153ZDanam Aviation LLC · Queen Creek, AZN9154PSloan James M Trustee · Grandbury, TXN9154YNolan Daniel R · Wilmington, NCN91553Simpson Josiah J L Trustee · Shelburne, MAN9155CN9155c LLC · Palm Harbor, FLN9155DTaylor Glenn Maurice · Fayetteville, GAN9155FMahoney Michael K · Neillsville, WIN9155PRegistered aircraftN9155VHickox Joseph C · Rollins, MTN9155WWiger Theodore L · Falcon Heights, MNN9156DTalmadge Jeffery K · New Milford, CTN9156HSolar Flying Club · Grimes, IAN9156JChristian Family Fellowship · Mesa, AZN9156SStickley Harold R · Wauseon, OHN9156VLegnaioli Richard · Cambridge, MDN9156YRegistered aircraftN9156ZEdney James A Md · Omaha, NEN9157CAims Community College · Greeley, CON9157EWillard James L · Prosser, WAN9157JAkn Inc · Crystal, MNFirst renewal noticeN9157PN9157p LLC · Mason, MIN9157SAdverse Yaw LLC · Albuquerque, NMN9157WFear David L · Hartford City, INN9158CSmith Robert A · Stillwater, OKN9158E7 J Aeroflight Publications Inc · Gruver, TXN9158HParrish Aviation Flight Academy LLC · Southlake, TXN9158VMellinger David S · Lusby, MDN9158WKirkhoff Robert A · Pottstown, PAN9158YLockwood Rick I · Garden Grove, CAN91596West Michigan Flying Club Inc · Norton Shores, MIN9159CConlon James E III · Longmont, CON9159HHess Garrett · Fullerton, CAN9159KRoss Andrew · Yamhill, ORN9159NBoeing Co · Renton, WAN9159VSmith Darryl Edward · Houston, TXN9159WDodson International Parts Inc · Rantoul, KSN915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeN915AZN915az LLC · Miami, FLN915CMVaayu Aviation LLC · Newark, CAN915CPCivil Air Patrol Inc · Maxwell Afb, ALN915GArcher Flight LLC · Wilmington, DEN915GWWills Gary W · Channahon, ILN915HPAnderson Austin C · Washington, DCN915JBKruger Karl A · Monterey, TNN915JCCannata Jack P · Roselle, ILN915JDDowling Jeffrey T · Poplar Grove, ILN915JTLd Aviation LLC · Durango, CON915KKKramer Kurt J · Volcano, CAN915LCardinal Flying Corp · San Jose, CAN915LFLingo Joshua B · Oak Grove, LA
Back to AD 87-10-06 R1