AD 71-13-01 R1
Registered aircraft · 6,916
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.
N643RLSouthwest Aviation Enterprises · Haslet, TXN644BCRegistration Pending · Sioux Falls, SDRegistration pendingN644CSTextron Aviation Inc · Wichita, KSN645BCNolan Kevin J · North Bend, ORN6460YRogers Anthony J · Boynton Beach, FLN6463UVip Leasing LLC · Mesa, AZN646CPCivil Air Patrol · Maxwell Afb, ALN646HCGraber Air LLC · Atglen, PAN646JSWashington State Patrol · Olympia, WAN6472YNorman Robert Alan · Zanesville, OHN6475LTerra Flight Aerial Imaging Inc · Spring, TXN647CPUnicorn Aviation Inc · Canton, CTN647SJRegistered aircraftN647TCWillis Communications Inc · Holly Springs, MSN6480YTechnical Education Services Inc · Virginia Beach, VAN6485YMeluskey Michael · Christiansted, VIN648TStefaniak Paul B · Richmond, TXN64APD&N Holdingsinc · Boca Raton, FLN64BMCoker Janie K · Tyler, TXN64GLStalagmite LLC · Demarest, NJN64RFLake Seawolf LLC · King Of Prussia, PAN64TWPlane Fun LLC · Garretson, SDN64USJc Investors Group LLC · Coral Springs, FLN64WMSeg Leasing LLC · Selinsgrove, PAN64WTTietmeyer Scott W · Grover, CON6501PGarcia Perez Alberto Carlos · Houston, TXN6503YShe-Rat Aviation Inc · Wilmington, DEN6507FToledo Thiago Amaral · Bonita Springs, FLN650KCPastor Stephen · Montgomery, TXN650MATerra Flight Aerial Imaging Inc · Spring, TXN650PA-Z Leasing LLC · Kenosha, WIN650TMSouthwest Construction & Property Management Inc · S San Fran, CAN6518YKiley Clement · Plainville, MAN651RMackey Aviation LLC · Talking Rock, GAN65234Moore Tommy Vance · Monahans, TXN6527YAll Pro Electrical Contractors Inc · Silsbee, TXN65280Jacobson David A Trustee · Bend, ORN652CPCivil Air Patrol · Maxwell Afb, ALN652JHausmann Aero LLC · Grand Forks, NDN652PLN652pl LLC · Saint Joseph, MON65309Satoyama Molokai LLC · Kaunakaka Molokia, HIN6531YSmith Henry C III · Essexville, MIN65324Bickerstaff Mike · Port Orange, FLN65348Anselmetti Federico · South Miami, FLN6537AYellow Jacket Aero LLC · Plymouth, MNN653PKBilavy Inc · Odessa, TXN653WWBerry Aviation Inc · San Marcos, TXN65431Caliber Capital Holdings LLC · Homosassa, FLN65445International Air Services Inc Trustee · Carson City, NVN65452Jf Aviation LLC · Minot, ND
Back to AD 71-13-01 R1