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.
N9338PDream Home Aviation Inc · New Smyrna Beach, FLN9338RMeshinsky Jeffrey · Alpine, CAN9338SGentilin Glen R · Camino, CAN9338VDheedene Nicholas · San Mateo, CAN9339JTruesdell Michael L · Tonopah, NVN9339NKadee Transportation LLC · Bucyrus, KSN9339PBreznik John D · Bradford, PAN9339VTechnical Education Services Inc · Virginia Beach, VAN933BKKreul Robert W · Waconia, MNN933CC27 Latitude LLC DBA · West Palm Beach, FLN933DSDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN933GCareer Pilot Training LLC · Wilmington, DEN933GYDemaria Steven M · Dacula, GAN933LTAerosim Flight Academy · Sanford, FLN933SCAb Prop Plane I LLC · Metairie, LAN933STSaratina Inc · Calhoun, GAN933TEBcaz Holdings LLC · Wilmington, DEN933XAndrews Richard S III · Guilford, CTN9340JLovelace Mario · Coral Springs, FLN9340MWeidner Mark · Cincinnati, OHN9340N9340n LLC · Broken Arrow, OKN9340SGarbade Richard L · Martinez, GAN9341CMerlin Aviation LLC · South Saint Paul, MNN9341HAndreas Neil A · Yakima, WAN9341MGabel Mark E · Oxnard, CAN9341SSantos Eric G · West Oneonta, NYN9341VAvalle Oscar A · Chicago, ILN9341WSleigh Jonathan B · Upland, CAN9342FChurchill David J · Bear, DEN9342HGutierrez Ricardo · Downey, CAN9342JDeschepper Sandra K · Independence, MON9342PTaulbee Gregory · Sarasota, FLN9342RCampbell Gene H · Baytown, TXN9342VClute Charles J · New Smyrna Beach, FLN9342WSmith Bradley W · St George, UTN9343DAva Aviation LLC · Tappan, NYN9343MStateline Trucking Inc · Fruita, CON9343VFundora Joel A · Altamonte Springs, FLN9344HBarnstormers Flying Club Inc · Pulaski, TNN9344JBiamonte Thomas John · Ventura, CAN9344LCivil Air Patrol Inc · Maxwell Afb, ALN9344PWheeler R Tyson · Frederick, MDN9344SScram Branden L · Fairbanks, AKN9344VOchoa Hougan Michael H · Chino Hills, CAN9344WEmery Nelson J · Emporia, KSN9345AAdamson Donald R · Lonoke, ARN9345JGrady John O · West Chester, OHN9345LHaynie Aviation LLC · Alexander City, ALN9345MMichael Matthew C · Ames, IAN9345PRegistration Pending · Gilbert, AZRegistration pending
Back to AD 87-10-06 R1