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.
N82813Preside Management Inc · Coachella, CAN8281CThomas Ken C · Fairbanks, AKN8281EAir Plains Services Corp · Wellington, KSN8281JJudy Gregory K · Hudson Oaks, TXN8281NTan Dexter E · Dallas, TXN8281PDubois Jean-Claude · Midlothian, TXN8281WNeisen Brandon L · Fowler, ILN8281YReined Out LLC · Nantucket, MAN82829Wingin It 13 LLC · Middletown, NYN8282JHoover Michael B · Ridgeland, WIN8282KNoyes Tony · Lewisville, TXN8282NMercury Aircraft Holdings Inc · West Monroe, LAN8282VEnsemble Air LLC · Laramie, WYN8282WBenker Albert J · Bevier, MON82832Stokke Todd · Magnolia, TXN82836Aerodreams Aviation LLC · Raleigh, NCN8283BFatiha Anouar · Columbus, INN8283JFurey Gale J · Bedford, NHN8283NRuth Joyce Aviation LLC · Henderson, TXN8283PPolzin Thomas H · Chippewa Falls, WIN8283VMiloud Chadd K · Fort Worth, TXN8283YPhillips Thaddus L · Knoxville, TNN8284JCrouch Scott M · Steamboat Springs, CON8284NHolland Alan L · Houston, TXN8284PTonry Richard Martin · Georgetown, TXN8284WCaldwell Darrel R · Panama City Beach, FLN8284YKahnke Richard Joseph · Mankato, MNN82859Schoeler George A · Ocala, FLN8285BHyldburg Aviation Inc · Plymouth, MAN8285EJames G Loy General Contractor Inc · Punta Gorda, FLN8285PPhillips Dale J · Michigan City, INN8285WBas Part Sales LLC · Greeley, CON8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeN82864Meyer Fredric Kim · Orange, CAN8286CMidwest Sky Chasers Nfp · Algonquin, ILN8286EPreston Richard R Trustee · Albuquerque, NMN8286NAyyildiz Erol · Glen Rock, NJN8286PStage Crew LLC · Clermont, FLN8286RHuhnke John F · Newburgh, INN8286YCoub Industries Inc · Fairfield, CAN8287Holloway Earnie G · Bonner Springs, KSN8287BCostanti Nicolas J · Medford, ORN8287JBurnett Stephen B · Granby, MON8287NBetik Patrick G · Grapevine, TXN8287PDeviny William M Jr · Arroyo Grande, CAN8287RHuhnke John · Newburgh, INN8287YLocust Hill Aviation LLC · Lewes, DEN8288AJohnson Carmen · White Cloud, MIN8288CRood James D · Winston, NMN8288EGomez Cierra D · Jasper, AL
Back to AD 87-10-06 R1