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.
N831SHHutchison Eugene W · Armagh, PAN831TSWingsleasing LLC · Wichita, KSN831VZMelbourne Flight Training LLC · Melbourne, FLN83208Rothrock Cara J · Streator, ILN8320AMendez Leonel Jr · Corpus Christi, TXN8320CRiffle Bruce H · Chesterton, INN8320PCallicrate Michael P · Saint Francis, KSN8320VThurman Randall N · Mcminnville, ORN8320WOracle Aviation LLC · Omaha, NEN8320YKling Aviation Inc · Friendswood, TXN83210Chapman Jeremy · Niagara Falls, NYN83212Salty Flights LLC · Labelle, FLN83213P-R Aircraft LLC · Snellville, GAN8321CJackson Blane · Beaufort, NCN8321HJust Plane Fellas LLC · Omro, WIN8321LArevalo Gilbert Jr · Loranger, LAN8321MFox Two LLC · Camino, CAN8321PSmoketown Helicopters LLC · Smoketown, PAN8321RThompson Grady R · Athens, ALN8321TRobinson Denise · Middletown, CTN8321WWeighman David R · Battle Creek, MIN8322EHorton Ernest J III · Galveston, TXN8322KSmith Gregory L · West Des Moines, IAN8322LHorizon Aviation Of Myrtle Beach LLC · Myrtle Beach, SCN8322PBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeN8322SAtp Aircraft 4 LLC · Wilmington, DEN8322V11 Point Aviation LLC · Alton, MON8322WLickteig Eric Kirk Trustee · Ellensburg, WAN8322YDayhoff Miller Alice J · Springfield, OHN83231Padilla Rafael R · Monee, ILN8323AWisconsin Aviation Inc · Watertown, WIN8323BMidcoast Helicopter Services Inc · La Ward, TXN8323FDavis William · Texarkana, TXN8323SOdell Ronald W · Peachtree City, GAN8323WConcord Aviation Services LLC · Concord, NHN8323YRochester Flying Club Inc · Rochester, NYN8323ZChapman Farms Inc · Vernon, CON8324EGc Aviation Services-1 LLC · Miamisburg, OHN8324PCirrus Air LLC · Eden, NCN8324TTango LLC · Chesterfield, MON8324USyren David N · Anchorage, AKN8324YStein Anthony J · Locust Grove, GAN8325EAnzaldi Carl J · Cherry Valley, CAN8325LLeading Edge Flight Services Inc · Hampshire, ILN8325RSy Aviation LLC · Judsonia, ARN8325TColumbia Jet Center Inc · Columbia, MON8325UCross Dustin · Tonto Basin, AZN8325VPct Hawk Inc · Wilmington, DEN8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKN83268Wright Kim B · Bozeman, MT
Back to AD 87-10-06 R1