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.
N36582Dias Paul Brian · Bakersfield, CAN36591Piper Aircraft Inc · Vero Beach, FLN365PBTruck Force One LLC · Homestead, FLN3661EPiper Aircraft Inc · Vero Beach, FLN36693Falcon Air LLC · Casper, WYN36716Smith Todd Andrew · Princeton, WVN36733Speedz Enterprizes LLC · Hannibal, MON367DKBonner Carl · Farmville, NCN367TZEquipco LLC · Kalispell, MTN36808Godwin Frederick H · Charlotte, TNN3699EPiper Aircraft Inc · Vero Beach, FLN369BGBrantley George · Carlsbad, NMN369CVVan Bortel Aircraft Inc · Arlington, TXN369GCCoyote Moon Ranch LLC · Otsego, MIN369GPFalcon & G2 Inc · Amelia Island, FLN369KJGrace Aire Inc · Corpus Christi, TXN369PMArapahoe Telephone Co Inc · Arapahoe, NEN369SHowitt John R · Reno, NVN369STAero-Mobil Inc · Wilmington, DEN369TCSchach Barbara G · Kirkland, WAN36BAAuerbach Gregory Brian · Swansea, ILN36CCjd Aviation LLC · Essex, CTN36PBMarin Pacific International LLC · Apple Valley, CAN36RECiconia Aeronautics LLC · Madison, MSN36RHRobin Hood Aviation LLC · Dunn, NCN36TPEichenour Daniel L · Willis, TXN3710MPrisbe Ernest · Los Altos Hills, CAN371AMPreuss Andrew J · North Charleston, SCN371MALets Fly LLC · Eugene, ORN371MCSale Reported · Palm City, FLSale reportedN371WAAkro Attitudes Inc · Lighthouse Point, FLN372DGWild Air LLC · Exeter, CAN372MABenham Properties LLC · Sullivan, INN3739EPiper Aircraft Inc · Vero Beach, FLN373EADallas Collins Prison Services Inc DBA · Devine, TXN373HPHandal Fred · Ladera Ranch, CAN373MAKropf Kevin G · Montrose, CON373WDBeardall Ann · Kiowa, CON3746PSale Reported · Fort Lauderdale, FLSale reported, canceledN374HPParrish Blake · Seminole, TXN374KCHostetter Swinea Aviation LLC · Dickson, TNN374MEKelley Aviation LLC · Crescent, IAN374PDavhen Aero LLC · Anderson, SCN374WFT2 Aviation LLC · Pahrump, NVN375CThornhill Jared Wayne · Shallowater, TXN375SRN375sr LLC · Hickory, NCN3760EWells Flying Services LLC · Holdrege, NEN3767QParsons John C · Wichita, KSN376HCMfd Aviation Inc · Middletown, DEN376MESpirit Air Inc · Salmon, ID
Back to AD 71-13-01 R1