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.
N702RASmtm Holdings Inc · Wilmington, DEN702RVWhipple Bruce F · Rockford, MIN702SBSierra Bravo Partnership · Liberal, KSN702SDVaughn Gregory T · Santa Fe, TXN702SPSportsmans Market Inc · Batavia, OHN702TBGoshen Shmuel · San Carlos, CAN702TKWells Lance L · Hanksville, UTN702XLeonard Steven E · Wichita, KSN7030JTtwn Media Networks LLC · New York, NYN7030PMartens And Wyatt Air Service LLC · North Platte, NEN7030RAlpha Kilo Aviation LLC · Wasilla, AKN7031ASmith Helicopters Inc · Cotulla, TXN7031BMason Crosby H · Zebulon, NCN7031CWestern New York Flying Club Inc · Bowmansville, NYN7031PTenkiller Flying Club · Tahlequah, OKN7031WEarl Hittle Aero Inc · Greenville, OHN7031ZSale Reported · Beresford, SDSale reported, canceledN70323Sky Equity LLC · Woodbury, MNN7032BNetherby Richard J · Wake Forest, NCN7032MProbst John D · Del Norte, CON7032PFast Twin LLC · Angola, INN7032WFleming William P · Tomah, WIN7032YBoonedocks LLC · Valley, ALN7032ZJones James William III · Lebanon, VAN7033FNaugler Winsor III · Fort Washington, PAN7033WRegistered aircraftN-number assigned, not yet registeredN70340Wings Over Texas Holdings LLC · Denton, TXN7034GFat Tyre Flyers LLC · Moses Lake, WAN7034QTesch David P · Pardeeville, WIN7034RMacallen Chemical Inc · Monroe, LAN7034WCooke Riley O · Bridger, MTN7034ZTexas Soaring Association Inc · Midlothian, TXN7035DWall Quinton · Clearfield, UTN7035GWilkening Owen A · Gardena, CAN7035QEarly Bird Aviation LLC · Phoenix, AZN7035WJerome Jeffrey A · Conneaut Lake, PAN7036DLoch Paul M · Miramar, FLN7036FLa Vigne Henry A · Hercules, CAN7036PPumphrey Vickie E · Devine, TXN7036WArizona Flying Pigs LLC · Flagstaff, AZN7036ZKnutson Wayne R · Tioga, NDN70376Sawyer Gregory T · Olga, WAN70378Vertol Systems Company Inc · Destin, FLN7037DRegistration Pending · Eagle River, AKRegistration pendingN7037GN7037g Inc · Newark, DEN7037QJohnson Joe N · Smithville, TNN7037RJames Jerome A · Sioux Falls, SDN70380Mindy Ltd LLC · Muscatine, IAN70386Johnson Ben A · Gainesboro, TNN7038BRogers Wayne D · Bellingham, WA
Back to AD 87-10-06 R1