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.
N7598WSmith Cameron · Billings, MTN7599CHurd Air LLC · Sioux Falls, SDN7599GJones James D · Linden, NCN7599JZurro Roger M · Freehold, NJN7599LAviation Pursuits Inc · Carrollton, GAN7599RHoffman Harold O · Andrews, TXN759CHadley Jean C · Benbrook, TXN759EEAcadiana Technical College · Lafayette, LAN759LBBrown Larry W · The Villages, FLN759STraining Planes LLC · Tampa, FLN75AKC U Later Aviation LLC · Holliday, TXN75ALTeebagy Steven C · Wellington, FLN75ARRegistered aircraftN75BFScussel Edward D · Albuquerque, NMN75BPPearce William R · Grants Pass, ORN75CEInternational Air Services Inc Trustee · Carson City, NVN75CJAngels Ten LLC · Norfolk, VAN75CMLowe Kenneth W · Sea Island, GAN75DFShelley Michael D · Murfreesboro, TNN75DRBurton Stuff LLC · Carlsbad, CAN75ECMaxson Phillip W · Green Cove Springs, FLN75GDCurren Scott N · Prospect, OHN75GPCross Colton · Allons, TNN75HDMorton Michael E · Hickory, NCN75HRMountain Flyer Aircraft LLC · Kalispell, MTN75JADomenick James V · Placitas, NMN75JEHammer Motion Pictures Inc · Indianapolis, INN75JGWhisenant Roy H II · Poway, CAN75JRWillis James R · Belleview, FLN75JWCompher Charles D · Berryville, VAN75KAmra Nabil W · Chaska, MNN75KAN75ka LLC · Fort Washington, MDN75KDJp1 LLC · San Angelo, TXN75KJSeiter Gene G · Pleasant View, TNN75KMEverett Kevin · Peoria, ILN75KRRoss Kevin · Granbury, TXN75LKN75lk LLC · Lafayette, LAN75LLDavis Air LLC · Phoenix, AZN75MMDonney Tom J · Sturgis, SDN75NSJohnson Dale B · Steele, NDN75PDHaher Thomas R · Tully, NYN75PHPaper House Av Inc · Locust Valley, NYN75RBBarr Air Patrol LLC · Mesquite, TXN75SDVimco N75sd LLC · El Paso, TXN75SEJansen Adam Roger · Sunnyvale, CAN75SGW E Love Ranch · Marfa, TXN75TBMorse George A · Prescott, AZN75TCMorales Luis · Florence, ORN75TDMcmonagle Donald R · Westcliffe, CON75TJSantos Jorge · Shafter, CA
Back to AD 87-10-06 R1