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.
N6TVTravelaire Service Inc · Wilmington, DEN6UCZborowski Ronald W · Eighty-Four, PAN6UKN6uk LLC · Goshen, INN6UULoerzel James E · Arlington Heights, ILN6VDEllison Jeremy · Dayton, NVN6WChase Roy M · Limington, MEN6WADue North Aviation LLC · League City, TXN6WEHigh Flight Aviation LLC · Harwinton, CTN6WNDart Gregory G · Mayville, NYN6XAFlying Farmers LLC · Dalhart, TXN6XCNorthstar Aerospray Inc · Clara City, MNN6XLCrowe Donald L · Mcallen, TXN6XQAccuracy 1st · Canadian, TXN6YGArcher Project Management LLC · Forney, TXN6YLHolman Leasing LLC · Anchorage, AKN6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKN6YQBeek Dudley E · Miami, FLN6YSHawk Aircraft Sales & Leasing LLC · Sterling Heights, MIN6YTCassinelli Steven W · Oceanside, ORN6YVZadrozny Pedro A · Wellington, FLN6ZHarris Hayden H · Chelsea, MIN6ZGTta Logistics LLC · Christiansted, VIN6ZHPetranek Diana C · Albion, NYN6ZPAmerican Patrols Inc · Midland, TXN6ZRBreed Paul T · Solana Beach, CAN6ZTLewis Eddy L · Cortez, CON700Dailey Jeffrey D · Weirton, WVN70000Carson Mark L Trustee · Northfield, MNN70004Gbl Aviation LLC · Laurel, MSN7000RJilek Peter Andrew · River Falls, WIN7000WIndy Air Sales LLC · Anderson, INN7000XWalsh Peter F · Walpole, MAN7000YSlowpoke Air LLC · Palm Harbor, FLN7001DOwens Eldon J · Arimo, IDN7001PPavlusik Tibor · Fort Mill, SCN7001WBrinc LLC · Lancaster, PAN7002PMonterey Bay Aviation Inc · Watsonville, CAN7002ZKistler Michael J · Wasilla, AKN70032Alpha Wings Inc · Willoughby, OHN7003BByrd Kyle E · Unionville, MON7003PAviation Career Enrichment Inc · Atlanta, GAN70046Zane Newton F · Rllng Hls Est, CAN7004FSouthern Vector Aerospace LLC · Huntsville, ALN7004GMcgreen John R · Albany, NYN7004REasley Leroy · Novelty, MOFirst renewal noticeN7004WLettsome Nesco · Beltsville, MDN7005Paragon Airplane Leasing Co · Fort Myers, FLN70052Hastings Heidi · Wasilla, AKN7005GHamilton Peter D · Bear, DEN7005QCentral Arkansas Flying Club Inc · Bryant, AR
Back to AD 87-10-06 R1