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.
N9175JSommer Eric M · London, OHN9175SMarshall Adam A · Fremont, NEN9175WHamilton Lee A · Franklin, INN9176Elias Bernard J · Hampton, GAN9176DSmaha Daniel B · Glide, ORN9176ETyrrells Trails LLC · Fairbanks, AKN9176GQs Aviation LLC · Laredo, TXN9176HSky Walker Flight School LLC · Adrian, MIN9176JPayson Aero Club LLC · Payson, AZN9176NWjr Aviation Inc · Caledonia, MIN9176PWalter Richard · Hampshire, ILN9177Chaffin Christopher · Flower Mound, TXN9177DCheyann Jordan · Coupeville, WAN9177EBell Joseph · Lakewood, CAN9177HLind Enterprises LLC · Manistee, MIN9177PCochran Charles M III · Terre Haute, INN9177SNabeth Jeremy S · Austin, TXN9177WBartels Gary A · Daykin, NEN9178CKelly Randall Shawn · Rocklin, CAN9178LClarke Paul W · Cape Girardeau, MON9178PCarnes Harley · Ocean, NJN9178QMartinez Manuel G · Downers Grove, ILN9178SSwoboda Kristin · Boise, IDN9178VWingman Aviation Partners LLC · Wentzville, MON9178WBoyd Dean W · Merrill, WIN91793Oexmann James Bennett · Lexington, KYN9179EFrisco Flyers LLC · Macedonia, ILN9179HMeteiver Lawrence J · Elkhart, INN9179SCharles Clarens · Brooklyn, NYN9179VVinter Mooney LLC · Philadelphia, PAN9179WVangura David · Ponte Vedra Beach, FLN917CFN917cf LLC · Tucson, AZN917CMKaraszewski Michael J · Pensacola, FLN917DKEncore Jet Management LLC · San Antonio, TXN917FAAlpha Aircraft International LLC · Lake Worth, FLN917GDAir Charter Inc DBA · Culebra, PRN917GKAmdel Holding LLC · Houston, TXN917GTCentral Airlines Inc · Leawood, KSN917KDRegistered aircraftN917MAKs Flying Club Inc · Manhattan, KSN917MBRegistration Pending · Ravenel, SCRegistration pendingN917PFBrown Charles James · Littlefield, TXN917SELarson Donald C · Evanston, WYN917TCDebarros David · Ashland, VAN917VKNorthern Lights Ventures LLC · Moose Pass, AKN917WETaylor William H II · Albuquerque, NMN917WSRv Time LLC · Cape Coral, FLN917WTStamsta David T · Ennis, MTN917XKirkegaard Lewis J · Grand Junction, CON917ZWRealmark Ovation Rv10 LLC · Cape Coral, FL
Back to AD 87-10-06 R1