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.
N926AJWalter Michael A · Middleburg, PAN926ASHanson William L · Auburn, CAN926BBBb Air · Stuart, FLN926BJUrban Gary E · Charlotte, NCN926BWTrade Winds Aviation Holdings LLC · Lewes, DEN926CAWilmington Trust Co Trustee · Wilmington, DEN926CKFly By Numbers LLC · Tallahassee, FLN926CPCivil Air Patrol · Maxwell Afb, ALN926DGPerkins James W · Georgetown, TXN926DKSuthar Jay P · Danville, VAN926EZEcho Zulu LLC · Middletown, DEN926GG2 Aviation LLC · Franklin, WIN926HBAwmr LLC · Conroe, TXN926JGGutwein Jan · Venice, FLN926JPJl Aviation LLC · Crestwood, KYN926MKToothman John C · Fairmont, WVN926MMGurewitz Alan · Thousand Oaks, CAN926MNPtw Consulting LLC · Atlanta, GAN926NLRemington Robert J · Sheboygan Falls, WIN926PACoco Aircraft Inc · Merritt Island, FLN926RUPottratz Dwane L · Beaverton, ORN926TCTango Charlie LLC · Gig Harbor, WAN926TEAnderson & Associates Inc · Little Rock, ARN926TMSwanson Richard E · Livermore, CON926WBBender Walter F Jr · Virginia Beach, VAN926WTArmadillo Aviation LLC · Scottsdale, AZN92704Gull Wing Flight LLC · Pt Pleas Bch, NJN9270DDowns Dennis D · Sterling, AKN9270KSlc Service Leasing Company LLC · Tipton, IAFirst renewal noticeN9270MMcmanus Nicholas A · Versailles, KYN9270PPenn Landmark Corp · Pinehurst, NCN9270SVinson Raymond R III · Mckinney, TXN9270VPhilippi Harrold Mark · Metairie, LAN92714Registered aircraftN92717Hold Fast Property LLC · Alto, NMN92719Mood Glen M · Ward Cove, AKN9271DGrasser Edward K · Palmer, AKN9271MCantelmi Richard L · Bethlehem, PAN9271RUpwind Aviation LLC · Mitchell, SDN9271SLife Is A Beech LLC · Commerce City, CON9271WMcelwee Jerilyn · South Riding, VAN92720Registration Pending · Champaign, ILRegistration pendingN92722Bryant David A · Walhalla, SCN92728Washington International Aviation LLC · Washington, DCN9272DMummy Mountain Med LLC · Paradise Valley, AZN9272HBlackbird 71 LLC · Rockford, ILN9272JEast Fork Flyers LLC · Lu Verne, IAN9272LValira Aviation II LLC · Oakland, CAN9272MSearle Jacob · Kuna, IDN9272PH&R Aircraft LLC · Kansas City, MO
Back to AD 87-10-06 R1