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.
N9789LGraham Michael · Fayetteville, GAN978ACNaples Air Center Inc · Naples, FLN978BCEvans Jennifer · Bozeman, MTN978CMDurkin Mike F · Cave Creek, AZN978RABdk Pegasus LLC · Bastrop, TXN978RSKlussman Barry · Waco, TXN978SPLlp Leasing Group LLC · Lewes, DEN978WCXin Han Aviation LLC · Helena, MTN9790GIsaac Gerald B · Spencerport, NYN9790JSheets Martin C · Fairmont, WVN9790MMoseley Samuel C · Arlington, TXN9790UParrish Rudolph S · Bath, MEN9790WZachmeyer Errol · Alexis, ILFirst renewal noticeN97919Christiansen Aviation LLC · Wilmington, DEN9791BHicks Keith · Sweetwater, TNN9791JAndersen Joshua J · San Antonio, TXN9791MThird Row LLC · White Rock, NMN9791QFly Chattanooga LLC · Ooltewah, TNN9791UWoods Joe · Newalla, OKN9791WSmith Gregory H · Dacula, GAN97921Flywell Aviation LLC · Bowling Green, KYN9792MHall Seth M · Waldoboro, MEN9792VHavu Aviation LLC · Irvine, CAN9792WTowner Flying Club · Pelican Rapids, MNN9793UMiyasaki Michael · Sacramento, CAN9793WCurtis Dana C · Roanoke, VAN97945Kent State University · Stow, OHN9794CTaylor Aero Flights Inc · Wilmington, DEN9794JSmith Patrick · Cary, ILN9794UBrown Joe T · Blevins, ARN9794VCooke George C IV Trustee · Richland, WAN9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedN9795CFernett Willard Shane · Peyton, CON9795UDargatz Marvin R · Las Vegas, NVN9795WSims Glenn C · Kingman, AZN9796CHellix LLC · Charlotte, NCFirst renewal noticeN9796JSchueneman Herbert Harry · Monterey, CAN9796VKelley Aircraft LLC · Weyers Cave, VAN9796WDale Robert W · Forney, TXN9797FBjork Lewis P · Taylorsville, UTN97983Wintill Gregory S · Roanoke, TXN97984Woody George R · Clinton, ARN9798JRoat Todd J · Rio, WIN9798PCorbett Harry F · San Luis Obispo, CAN9798UKuhagen Garth H · Courtland, CAN9799JN9799j Aviation LLC · Allen, TXN9799UGoff Vernon L · Omaha, NEN9799WBranchizio Christopher · San Antonio, TXN979AArcher Aero LLC · Wilmington, DEN979CSkywest Leasing Inc · St George, UT
Back to AD 87-10-06 R1