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.
N8897NAnderson Leroy H · San Angelo, TXN8897PFey Ray D · Middleton, WIN8897YAvion LLC · Lewes, DEN8898DWelty Donald Robert Jr · Glennallen, AKN8898JColt 45 LLC · Tulsa, OKN8898NTaylor Danny H · Defuniak Springs, FLN8898WWade Harry Jr · Helotes, TXN8898YWickenheiser Kenneth W · Sun City, AZN8899ERgp Aviation LLC · Wilmington, DEN8899LSujet Dylan P · Hampton, NJN8899PLavoie Paul · Macon, GAN8899YSture Joel M · Anchorage, AKN889ACKdx Air Ventures LLC · Naples, FLN889DQualitair LLC Trustee · MichelstadtN889DALeik Aviation LLC · Dousman, WIN889EHMillhouse Eric L · Cheyenne, WYN889FNe Ia Helicopter LLC · Tekamah, NEN889GSKlock Dexter F · Driggs, IDN889JDByxbee John · Greenville, SCN889MHExtreme Helicopter Service LLC · Alice, TXN889SCCrawford Stevan L · Woodinville, WAN889TJvs LLC · Santa Rosa, CAN889TTFlying Farmer LLC · Wilmington, DEN889ZMaule N889z Inc Trustee · Wilmington, DEN88ABBrown James L · Athens, ALN88ACSegerstrom William C · Sunriver, ORN88AKState Of Alaska · Anchorage, AKN88APLangdon Brian B · Newcastle, WAN88AVN88av LLC · Fort Myers, FLN88BELee George M · Queen City, TXN88BSBachman Jared R S · Elbert, CON88BWRegistered aircraftN88CMTurner Ronald A · Tulsa, OKN88CTCameron John W · Canby, ORN88CVAllen David L · Sturgis, SDN88CXChamplin Aviation LLC · Kerens, TXN88DAAnderson Darin D · Eatonville, WAN88DEMatta Figueroa Eduardo · Chapman, KSN88DKPitts Cabot J · Palmer, AKN88DRAkerson Charles J · Clarksville, TNN88EStarlite Aviation Technologies LLC · Las Vegas, NVN88EFPeyton Craig L · Rhinebeck, NYN88ETGelfan Russell A · Bellingham, WAN88EWAviat Aircraft Inc · Afton, WYN88FVandivort Aaron · Jacksonville, FLN88FBGeary Travis S · Viroqua, WIN88FCSandlapper Aviation Of De Inc · Bennington, VTN88FNSaline County Flyers Association LLC · Little Rock, ARN88GEGothreaux William A · Deridder, LAN88GGSchneck Doreen Trustee · Albany, GA
Back to AD 87-10-06 R1