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.
N9112WCherokee N9112w LLC · Boise, IDN9112ZWalters Darren · Overland Park, KSN9113KBaja Airventures Inc · Chula Vista, CAN9113LZimin Carl E · Naknek, AKN9113VBarry Dustin Michael · Highland, ILN9113WFlying Magic LLC · Post Falls, IDN9114DMacair Aviation LLC · Xenia, OHN9114EParkerson Stanley L · Fairbanks, AKN9114HRohwer Michael G Trustee · Tucson, AZN9114JRouss Charles F · Martinsburg, WVN9114PRegistered aircraftSale reported, pending cancellationN9114TFlying Frog Aviation LLC · Palm City, FLN9114VTayl Number Aero LLC · Tontitown, ARN91150Itsacinch Inc · Mer Rouge, LAN91151Dagnon Scott R · Bozeman, MTN91154Ellingson Daniel E · Stuart, FLN9115DRoods Shawn R · Billings, MTN9115FMccaffree Andrea J · Shepherd, MTN9115PHartley Christopher · Fort Worth, TXN9115QSoto Daniel-Rey · Smiths Station, ALN9115VBovo Paolo · San Benito, TXN9116DPeterson Lauren R · Anchorage, AKN9116JPolcyn Matthew D · Millersburg, OHN9116LShowers Of Blessings LLC · Fredericktown, MON9116PMaierhoffer Henry F Jr · Sylvania, GAN9116TSkinner Jay D · The Woodlands, TXN9116WKoury Michael Jacob · Fort Mohave, AZN9116ZIron 17 Investments LLC · Mount Pleasant, TXN9117CRegistered aircraftN9117LWillkris Aviation Services LLC · Smithfield, VAN9117PRenewable Fuels Consulting Inc · Clear Lake, IAN9117QBenson Joshua J · Winchester, CAN9117VEdgerton Bruce M · Ottsville, PAN9117WLittle Wing Aero LLC · East Longmeadow, MAN91187Usda Aphis Ws Atoc · Cedar City, UTN9118CWalter Tina R · Yorkville, CAN9118DYaggie Equipment LLC · Breckenridge, MNN9118LDavis Brett M · Madison, MEN9118SSt Pete Aviation Services LLC · Saint Petersburg, FLN9118WHalford Robert · Troy, TXN9118ZFlying Mermaid LLC · Aiea, HIN9119DArne Blair V · Carpenter, SDN9119JAlex Aircraft LLC · New Albion, NYN9119LPiercy Ronald S · Moses Lake, WAN9119PChapman Charlie Jr · Lubbock, TXN9119RMiller Robert III DBA · Kittrell, NCN9119TDahab Richard E · Brightwaters, NYN9119VCarlson Tracy W · Henderson, NVN9119WBas Part Sales LLC · Greeley, CON9119XSmith Gregory W · Weirsdale, FL
Back to AD 87-10-06 R1