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.
N73563Hamms Lake Development Inc · Crown Point, INN7356GHolcomb John R · Siloam Springs, ARN7356JHyatt Philip D · Gadsden, ALN73573Sullins Tyler L · Boerne, TXN73574Wingsleasing LLC · Wichita, KSN73577Benton Frederick N · Weed, CAFirst renewal noticeN73579Officer Properties LLC · Broken Arrow, OKN7357DColton F D · Canby, ORN7357JCswnz Inc · Wilmington, DEN7357PMelvin Ryan C · Hamilton, GAN73581Beaumont Ladonna L · Athol, IDN73585Anderson Dale S · Corona, CAN7358DBagley S G · Suwanee, GAN7358GN7358g Inc · Las Vegas, NVN7358YPmx Aviation Services LLC · Kailua Kona, HIN73596Russellville Aviation Inc · Russellville, ARN7359JAdams Daniel W · Maryville, TNN7359TKort Thomas J · Lake Tomahawk, WIN7359WHumphrey Eric N · Osceola, IAN7359YAwmr LLC · Conroe, TXN735FLInternational Air Services Inc Trustee · Carson City, NVN735MCd Engineering LLC · Bennington, VTN735PUAdams Aviation Services Inc Trustee · Wilmington, DEN735QStuart Aviation Holdings LLC · Stuart, FLN735RCSoto Flavio Cesar · Nogales, AZN735SW5 Sierra Whiskey LLC · Sonora, CAN735TAAnderson Jerry S · Winchester, TNN73601Flex Air Holdings Inc · San Diego, CAN73603Davis Kevin L · Lodi, CAN73604Registration Pending · Raleigh, NCRegistration pendingN73605Jkg LLC · Murfreesboro, TNN7360DMettler Daniel G · Menno, SDN7360WLudwig Paul P · Algonquin, ILN73610Stroup David L · Pottsboro, TXN73619Jones & Co LLC · Londonderry, NHN7361RMcafee Scott A Trustee · Clifton, TXN7361WRichart Mark D · Canton, PAN7361XJohnson Michael · Huntington Beach, CAN73622Dove Kenneth F · Danville, CAN7362GKeno Leasing LLC · Monroe, LAN7362WWinterberg Jeremy · Auburndale, FLN7362XDraco Flight School Inc · Chino, CAN7362Y32 Drakes LLC · Sulphur Bluff, TXN7363EWilkins Raymond E · Osceola, IAN7363GFlying High Again LLC · Mount Juliet, TNN7363PJansen David C · Newnan, GAN7363WBurke David L · Sturgeon Bay, WIN7364JLewis Mark A · Ozark, ALN7364PMarotta Thomas E · Twin Lake, MIN7364RCentral Shop LLC · Shadyside, OH
Back to AD 87-10-06 R1