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.
N8352DScarlet Wings LLC · Brunswick, OHN8352LFielding David · Scarborough, MEN8352RQuantum Aviation LLC · Wauna, WAN8352TFlight Inc · Lakewood, CON8352WLebanon Flying Club · Lebanon, MON8352YSkylandsair LLC · Port Orange, FLN83539Silbersiepe Thomas E · Catlett, VAN8353COstwinkle Jeffrey J · Justin, TXN8353DKauffman Land & Development LLC · Fort Lupton, CON8353HThompson Rufus · Oceanside, CAN8353MCrosswind Leasing LLC · Prescott, AZN8353RSchrandt Mark L · Shoreview, MNN8353WN8353w Flyers LLC · North Las Vegas, NVN8353YSoutheast Leasing LLC · Delray Beach, FLN83540Red Tail Scholarship Foundation · Tuskegee, ALN83545Mayeur Clint · Wasilla, AKN83549Giacometto John T · Broadus, MTN8354CTayab Farooq · Allen, TXN8354JOld Buzzard Aviation Inc · Middleburg, FLN8354LEast Texas Imperial Petroleum LLC · Flint, TXN8354QKandravi Enterprises Inc · Centereach, NYN8354RStonebrink Grant · Boonton, NJN8354WCoombs Eric S · Louisburg, NCN8354YMiles Dan · Saint Augustine, FLN8355AEmerald City Aircraft Leasing Inc · Port Orchard, WAN8355EHigh Noon Leasing LLC · Anchorage, AKN8355HLjmf 17 LLC · Hays, KSN8355PSutliff Larrie G · Briarcliff Manor, NYN8355XSkyway Leasing Co Inc · Yakima, WAN83566Downes Dennis G DBA · Saltsburg, PAN8356ESky West Aviation Inc Trustee · Albuquerque, NMN8356JWissam Habbal · Rosamond, CAN8356PEarl Tim G · Plymouth, CAN8356REmerald City Aircraft Leasing Inc · Port Orchard, WAN8356WSmith Randall K · Wilton, CAN83572Pacific Aviation LLC · Cottage Grove, ORN83573Frazier Aviation LLC · Ontario, ORN83577Ennen Rick M · Bottineau, NDN83579Mak Air Ventures LLC · Smithfield, NCN8357PHames David W · Amarillo, TXN8357RRegistration Pending · Fort Worth, TXRegistration pendingN8357VHaas Daniel S · Camarillo, CAN83580Lazy Ye Cattle Co · Dodson, MTN83582Johnson Gavin Howard · Anchorage, AKN8358FHolt Helicopters Inc · Uvalde, TXN8358LOc Flight Lessons LLC · Costa Mesa, CAN8358MSky Blue Holdings LLC · Park City, UTN8358RHight Mayon C · Snohomish, WAN8358WChaney Eddie L · Douglas, GAN8358YGruenbaum Michael S · Eastvale, CA
Back to AD 87-10-06 R1