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.
N9707DPapke Brian D · Beulah, MIN9707LGriffith Jonathan E · Newark, NJN9707MCombs Charles D · Buffalo, MON9707PN B Tweet & Sons · Nome, AKN9707WBulger Edward P · Amesbury, MAN9708FDodson International Parts Inc · Rantoul, KSN9708JGautsch Michael J · Onalaska, WIN9709BPeterson Air LLC · Chisago City, MNN9709DPearce Ricky · Parsons, KSN9709KLkn Cherokee LLC · Mooresville, NCN9709MAndersen Michael S · Bensenville, ILN9709QRobles Andres M · Plantation, FLN9709WStewart Glen W · Lebanon, TNN970ACNaples Air Center Inc · Naples, FLN970LCMajeste Air LLC · Loveland, CON970PGJoyful Flight LLC · Madison, WIN970WCCavorite Aviation LLC · Lehi, UTN970WMMartin James Louis Trustee · Reno, NVN9710FAtp Aircraft 4 LLC · Wilmington, DEN9710JThompson Stephen N · Hagerman, IDN9710QBluesky A24r LLC · Nashville, TNN97116N97116 LLC · Hector, MNN9711MKats Daniel L Jr · Labelle, FLN9711PTop A Farms Inc · Benkelman, NEN9711UDakota Ear Nose & Throat Clinic Pc · Sturtevant, WIN9711WChapman Darren P · Winter Haven, FLN9712JBowers Nicholas M · Mount Hope, WIN9712NKeller Gerald C · Kokomo, INN9712UUnruh Ronald E · Pampa, TXN9713DBallard Gary B · Leslie, ARN9713PMeggers Roger D · Baker, MTN9713URoderick Richard · Farmington, NMN9713WGiles Robert L · Columbia, SCN9713YEsteban Rioufol Peralta · Houston, TXN9714DVermeire Calvin L · Soldotna, AKN9714LWebaire LLC · Slidell, LAN9714PGilman Robert L · Wasilla, AKN9714UWeyers Gregory J · Lakewood, WIN97154Poddoubnyi Andrey Alexandrovich · Vista, CAN9715CBragg Larry M · Kansas City, MON9715DMccullough Robert · Carlton, WAN9715JFly By Faith LLC · Laurel Springs, NCN97163Civil Air Patrol Inc · Maxwell Afb, ALN9716DKappele Arthur J · Crystal River, FLN9716LOettmeier Bert W Jr Trustee · Leawood, KSN9716MAshton Flyers Inc · Ashton, IDN9716PGreater Boston Soaring Club · Sterling, MAN97172C P Aviation · Santa Paula, CAN9717BCeruto Jorge · Auburndale, FLN9717CMiloud Chadd · Fort Worth, TX
Back to AD 87-10-06 R1