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.
N7440JChagnot Louis P · Tolland, CTN7440PSutton Aircraft Salvage LLC · Palmer, AKN7440WMorsi Sameh M · Pomona, CAN74410Beran Jonathan R · Marshall, TXN74415Flying Low Enterprises LLC · Kenai, AKN74416Otto Joel C · Lander, WYN74417Wright Edward J · Louisa, VAN7441GSussex Aero Maintenance Inc · Georgetown, DEN7441JGuldi James E · Port Orange, FLN7441SKp Stunt Productions Inc · Burlington, NDN7441YHatton Leslie A · Chesapeake, VAN74429Xinther LLC · Belle Mead, NJN7442PBalske Curt A · Bedford, TXN7442WDenney David L · Oak Grove, ORN7442YMy Toys Inc · Jacksonville, FLN74434Lyet J Paul · Lititz, PAN74435Sutton Aircraft Salvage LLC · Palmer, AKN74438Pearl Jonathan D · Ocean City, MDN74439Costanza Frank V · Picayune, MSN7443JPiper Aero Adventure LLC · Port Orange, FLN7443RClarkson Brett D · Stuarts Draft, VAN74442International Air Services Inc Trustee · Carson City, NVN74447South Texas Aviation Group Inc · Helotes, TXN7444DRups Adventure North LLC · Arbor Vitae, WIN7444RMarchionda Bruce · Sherman, TXN7444WMedia Stew LLC · Carson City, NVN74451Continuous Improvement Solutions Llp · Bella Vista, ARN74452Delmarva Skies LLC · Milton, DEN74453Wientjes Randy R · Metropolis, ILN74458Flying Tiger P40 LLC · Healdsburg, CAN7445JNosal Ivan · Itasca, ILN7445PN7445p Flying Club LLC · Union City, CAN7445WArola Anthony L · Tacoma, WAN7445YCherish Aviation LLC · Woodbridge, VAN74465Clarabut Alexander · Santa Clara, CAN7446DNeufeld Bernie T · Dalhart, TXN7446FAir Sprayers Inc · Two Buttes, CON7446JLkn Aviation LLC · Cornelius, NCFirst renewal noticeN7446REckert Travis R · Texarkana, TXN7446YN7446y Aero LLC · Joplin, MON74470Barbeau Timothy A · Saint Peters, MON74472Willis John B · Katy, TXN74478Sato Steven S · Green Bay, WIN7447JWiley Calvin · Summer Shade, KYN7447NJc Flight Inc · Wilmington, DEN7447RCompo John · Essex Junction, VTN7447VBaca Robert A Trustee · Auburn, CAN74481Holley Jack · Morehead, KYN7448PBurshem Ben E · Bay City, WIN7448RCraddock Ellis G · Colorado Springs, CO
Back to AD 87-10-06 R1