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.
N6455PHussey Wilfred Lee II · Martinsville, VAN6455SDaniel L Cooper · Palmer, AKN6455VCrown Flying Club Inc · Olathe, KSN6456JCherokee Dream Inc · Wilmington, DEN6456QLeehey Studio LLC · Santa Monica, CAN6456RCash Douglas Edward · San Antonio, TXN6456ZSimmons Aviation Services LLC · Pawcatuck, CTN64575N64575 LLC · Cheyenne, WYN6457DTristar Aviation Services LLC · Hendersonville, TNN6457JHatcher Clifford J · Dallas, GAN6457QRegistered aircraftN6457WWeston Keith M · Ogdensburg, NYN64585Lay Lawrence W · Douglass, KSN6458JFlorida Tectonics Inc · Weirsdale, FLN6458PHutchison Joseph C · Mebane, NCN6458VWilson David P · Lumberton, TXN6458WJones Larry · Clovis, NMN6459LFalcon Financial Solutions · Meadow Vista, CAN6459PJaeger Timothy S · Mukwonago, WIN6459RLogical Drive Inc · Siler City, NCN6459ULinck Market Inc · Little Rock, ARN6459WBillingsley Littleton C Jr · Spicewood, TXN645AWHobart Aviation Inc · Akron, OHN645BCNolan Kevin J · North Bend, ORN645BHFedors David · Palmdale, CAN645DBBailey Dennis L · Oakdale, CAN645DDAmes Donald L Trustee · Park City, UTN645DTScenic Mountain Air Inc · Moose Pass, AKN645EJFogelin Eric S · Shasta, CAN645FLRule Charles Y · Mineral Point, WIN645FTFlorida Institute Of Technology · Melbourne, FLN645LCJohnston Laura S · Seattle, WAN645NDUniversity Of North Dakota · Grand Forks, NDN645RD&S Development LLC · Spring, TXN645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTN645RFHagge Hal E · Eagle River, AKN645SStewart Dennis M · Fernley, NVN645SAGerrish Ronald M · San Antonio, TXN645SDDacy Julia A · Harvard, ILN645SPRegistration Pending · Bennett, CORegistration pendingN64608A S Air LLC · Lantana, FLN6460DVan Wagner Aerial Media LLC · Hollywood, FLN6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEN6460QDel Gado Raul L · Victorville, CAN6460TDavey Douglas H · Worley, IDN6460UHayes Toby G · Idaho Falls, IDN6460YRogers Anthony J · Boynton Beach, FLN64611Great North Air LLC · Shelburne, NHN64617Melbourne Flight Training LLC · Melbourne, FLN6461CTripacer Strategic Consulting LLC · Dover, DE
Back to AD 87-10-06 R1