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.
N74535Rodgers Doyle W · Longview, TXN7453DRomo Blaine Jeffrey · Dillingham, AKN7453GNorthwoods Flyer LLC · Jacksonville, FLN7453YStratus Air Services LLC · Punxsutawney, PAN74541Premier Helicopters LLC · Carson City, NVFirst renewal noticeN74542Bauerle Lucas W · Albuquerque, NMN74543Sky Solutions LLC · Detroit, MIN74545Hopkins Tim W · Cincinnati, OHN74547Travierso Alan S · Farmington, UTN74549Woodyard Tory · Mcloud, OKN7454GDaniel Dewey R · Okeechobee, FLN7454PCreation Industries LLC · Middlefield, OHN7454WPorter Robert D · Manchester, TNN7454YOrthner Aviation LLC · Chattanooga, TNN74553Young John H · Sheridan, WYN74555Pieszala John W · Larksville, PAN74556Gutierrez Juan · Sarasota, FLN74557N74557 LLC · Kissimmee, FLN7455DD'Amico Joseph J · Mount Ary, MDN7455PEagles Aviation LLC · Rocklin, CAN7455RMcanelly Anthony J · Maricopa, AZN7455SSharp Penny E · Ocala, FLN7455WNicolai Tim A · Brandon, SDN7455YTowns Bobby · Nashville, TNN74560Willett Lynn B · Wooster, OHN74561George James H · Punta Gorda, FLN74562Hamm Donald S · Carrollton, TXFirst renewal noticeN74563Black Bird Holdings LLC · Gilbert, AZN74564November Alpha LLC · Dover, DEN74565Shai Evan · Oak Bluffs, MAN74566Kerns Stanley M · Berryville, VAN74568Willis Charles D · Katy, TXN7456GGregory Larry C Trustee · Farmington, MON7456JSchwier Ronald G Jr · Bloomfield, NJN7456PInternational Air Services Inc Trustee · Carson City, NVN74571Mccurry Richard H · El Dorado, CAN74573Strout Adam Geoffrey · Manchester, MAN74574Burrell Helicopters LLC · D Hanis, TXN74576Varnes Mark R · Westminster, CAN74579Bethell A Ray · Heavener, OKFirst renewal noticeN7457JMoretti Stephen B · Cranston, RIN7457LPiper Lover LLC · Centennial, CON7457RFoster Adam W · Midland, TXN7457WNilsson Tim E · Yreka, CAN7457YPeter Prince Aviation Center LLC · Milton, FLN74581Lane Tyler R · Berthoud, CON74582Moo Nee LLC · Vero Beach, FLN74583Mile High Carpet Rides LLC · Dover, DEN74586Rainwater Farms LLC · Dover, DEN74587Curtis David W · Watertown, NY
Back to AD 87-10-06 R1