AD 71-13-01 R1
Registered aircraft · 6,915
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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.
N146RFValiair Limited Co Trustee · Casper, WYN14702Cartel Oil Records LLC · Kansas City, MON1470BBerger Leo · Nampa, IDN14714Poco Loco LLC · Mesa, AZN14734Thorman Bryan R · Grand Junction, CON14746Kashiwa Charles · Glens Falls, NYN14747Hausken Matthew · Centuria, WIN1474TStella Stephen G DBA · Fort Lauderdale, FLN14758Jim Franklin Aviation Service Inc · Ruidoso, NMN147AJAviation Solutions LLC · Louisville, KYN147CETwin P Aviation LLC · Fort Worth, TXN147FBrown Helicopter Inc · Pensacola, FLN147GWAllen Air LLC · Creola, ALN147PASetki Air LLC · Wilmington, DEN147PJVargas Luis A · Isabela, PRN147SASteeda Autosports Inc · Pompano Beach, FLN1483CWang Helin · Dana Point, CAN1485CLiebowitz Alan · Sioux Falls, SDN148DWVantage Aviation USA LLC · Tampa, FLN148GHLattimore Partners LLC · Fort Worth, TXN148HPAlternative Travel LLC · Loveland, CON148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN148RFPaklook Air Inc · Bethel, AKN149ABVarga Miklos · Helendale, CAN149DWRbf Aero · Wilmington, DEN149GRJoemchem LLC · Sparta, TNN149MMJsk Leasing LLC · Valparaiso, INN149PCSubick Leonard · Spring City, PAN14APGlobal Air Concepts LLC · Anchorage, AKN14DWBurnett Timothy S · Birmingham, ALN14GSKerner Robert · La Vergne, TNN14PCAlooment LLC · Las Vegas, NVN14SFArnold Kiefer · East Prairie, MON14SGBorts Gerald S · Altadena, CAN14WLTextron Aviation Inc · Wichita, KSN14YPHubbard Scott Edward Jr · Deatsville, ALN14YVN14yv LLC · Oklahoma City, OKN1501TRegistered aircraftN15031Young J D · Plano, TXN15036Avocation Aviation Inc · Muncie, INN15040Foote Samuel Henry Trustee · Paradise Valley, AZN150FCHart John Jr · Vallejo, CAN1512FJordan S G · Wasilla, AKN1512X4js Inc DBA Great Country Motors · Sun City, AZN15137Cart Caleb L · Eunice, LAN15172Transit William B · Macomb Township, MIN15198Kehl Bryan R · Moorpark, CAN151LTBoss Dog LLC · Sheridan, WYN151PAIntermountain Fabrication LLC · Jerome, IDN151STWildman Lake Lodge Inc · Anchorage, AK
Back to AD 71-13-01 R1