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.
N9142JKormash John A · Edgewater, FLN9142KSwales Michael K · Harrisville, MIN9142PErickson Ralph E · Foristell, MON9142WArtman Holdings LLC · Safford, AZN9142ZLippity Clippity Aviation LLC · Muskegon, MIN9143DHellberg Farms LLC · Lowden, WAN9143JN9143j LLC · Fort Wayne, INN9143SBooton Charles E · Navarre, FLN9143VCrazy Mountain Cub LLC · Helena, MTN9143WLara Anthony Michael Thomas · Manitou Springs, CON9143XCt King Airplane LLC · Snohomish, WAN9144CMazzara David J · Collierville, TNN9144PKober Kelly W · West Chester, PAN9144TShiflett Philip B · Marietta, OHN9144VHardin Ralph · New Plymouth, IDN9144WMedema Roger E · Lake Forest, ILN9145CReitz Andrew P · Pembroke Pines, FLN9145JBonertz Brian J · Muscatine, IAN9145VRoe Cameron · Salt Lake City, UTN9145XHk Aero LLC · Wilmington, DEN9146DSmith Paul G · Wasilla, AKN9146JSwarey Steven · Whiteville, TNN9146KBartlett Jesse Charles · Henderson, NVN9146LMalone Aaron E · Wasilla, AKN9146PBlack Diamond Aviation LLC · Levelland, TXN9146VWood David Allen · Conyers, GAN9146WGam Aviation LLC · Sioux Falls, SDN9147PDesouza Ian · Binghamton, NYN9147THoiles Richard C · Shortsville, NYN9147VN206ht LLC · Pulaski, IAN9147WBishop Samuel E · Soquel, CAN9147XInfinity Aviation Group LLC · Nashua, NHN9148DSky Blue Aviation LLC · Hershey, PAN9148GCheutin Didier V · Orlando, FLN9148JNovember Nine One Four Eight Juliet LLC · Fulton, MON9148PJohnson T J H · Franklin, MIN9148SBlue Skies Aviation LLC · Holland, MIN9148WD & D Kaye Inc · Santa Clara, CAN9148XFaik Salaheddine · Marion, IAN9149CBryan Robert G · New Lenox, ILN9149JJones Lynn · Birmingham, ALN9149PJustack Aviation Inc · Columbus, INN9149QCovington James A · Huntsville, ALN9149SBurnard Russell J · Seward, AKN9149WTcherneshoff Robert · Clayton, NMN9149XJohnson Daniel C · Mount Hope, KSN9149YBest Crane & Equipment Co LLC · Wilmington, DEN914ADDepinet Andrew P · Galion, OHN914AMWilliamson Tom P · Nacogdoches, TXN914AZN969az LLC · Miami, FL
Back to AD 87-10-06 R1