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.
N81749Friend Aircare Inc · Washington, PAN8174MFlight Time Builders Inc · Memphis, TNN8174PIglewski Rudolph Daniel II · Apache Junction, AZN8174WJeffers Coreen · Bellmawr, NJN8174XJones Aaron B · Bruceton Mills, WVN8174YStansbury Todd V · Centennial, CON81756Jrny Air LLC · Everett, WAN8175CYates Trucking Inc · Quartz Hill, CAN8175EHigh Planes Aviation LLC · Goodland, KSN8175HHowe Richard B · San Luis Obispo, CAN8175NClassical Organs Of Texas LLC · Liberty Hill, TXN8175PCunningham James L · Tucson, AZN8176CShaffer Glenn · Vinemont, ALN8176PHundley Jeffrey S · Parker, CON81771Skyfusion II LLC · Atlanta, GAN81774Pc Limited LLC · N Dighton, MAN8177NAspiras Dionisio O Jr · Rosharon, TXN8177WDavis James Warren · Albemarle, NCN8177YElite Approach LLC · Chesterfield, MON81795Flat Land Aviation & Training LLC · Seward, NEN8179AFelker Lonnie A · Burbank, CAN8179HSam Air LLC · Daphne, ALN8179NFletcher William J · Mason, NHN8179THill Jason M · Bakersfield, CAN8179WLynch Gary L · Ocala, FLN8179ZGambacorta Paul E · Leonardtown, MDN817ABHawaii Pacific Aviation Inc · Kailua Kona, HIN817ACCannon Air Force Base - Aero Club · Clovis, NMN817AKZweifel Brad · Palmer, AKN817BWWalker Baylor L · Big Spring, TXN817CPCivil Air Patrol · Maxwell Afb, ALN817DHMastrangelo John A · Phoenix, AZN817DMRegistered aircraftN817GAtp Aircraft 9 LLC · Wilmington, DEN817HAIasco Flight Training Inc · Redding, CAN817HSMoore Stephen T · Ellensburg, WAN817JJenkins Jay T · Burnsville, MNN817JCCain Jerome M · Lincoln, MTN817JVRusyniak Anthony J · Syracuse, NYN817KBaquero Eric P · New Castle, CON817KCCrawford Michael R · Gainesville, GAN817LHHavelka Lambert H · Mc Gregor, TXN817NDUniversity Of North Dakota · Grand Forks, NDN817TFAir Fleet Holdings LLC · Missoula, MTN817TRRobinson Trent · Havana, FLN817YLandon William Walton IV · Fairbanks, AKN817ZBennett Condon P · Stormville, NYN81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKN8180CSnoopy Air LLC · Kalispell, MTN8180DBobert Bunny LLC · Wilmington, DE
Back to AD 87-10-06 R1