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.
N5231MElliott Cedric · Huffman, TXN5235BBrit Ltd · Wilmington, DEN5236UVan Bortel Aircraft Inc · Arlington, TXN5236VT And G Investments LLC · Gulfport, MSN5237YWerninghaus Karla I · Reno, NVN5238HGalatians182 LLC · Kalispell, MTN52394Aero Missions LLC · Zeeland, MIN523MLForster David · Friendswood, TXN523PHNby Productions · Bristow, VAN523SPArkansas State Police · Little Rock, ARN5241SHpt Aero LLC · Longboat Key, FLN5242STanakon Inc · Fairbanks, AKN5242URegistered aircraftN5243TBayley Inc · Henderson, NVN52449Nyama Leo LLC · San Antonio, TXN5244QVan Bortel Aircraft Inc · Arlington, TXN5246SPapa Kilo Aviation LLC · Palm Beach, FLN5247FBasha Joseph W Jr · Alexandria, LAN524ERGrant Aviation Inc · Anchorage, AKN524KCEmanon LLC · Apex, NCN5251SHegarty Joseph L · Sioux Falls, SDN5253ALet Industries LLC · Lewes, DEN5255QScott Michael S · Las Vegas, NVN5258SPace Aviation LLC · The Woodlands, TXN5259SSquier Robert J · Royal Oak, MIN525JFMoray Eel LLC · Vail, AZN525MGN525mg LLC · Menlo Park, CAN525MJCohen Heath P · Lake Havasu City, AZN5262QReinhart Gregory D · Waunakee, WIN5262SSalls Robert A · Glen Mills, PAN5263TBackroads Aviation LLC · Holdrege, NEN52642Valiair Ltd Co Trustee · Casper, WYN5264RHenslee Aviation LLC · Hobbs, NMN52657Honeycutt Holdings Inc · Charlotte, NCN5265SEagle Aeronautics LLC · Chicago, ILN5266GMtf Aviation LLC · Salem, ILN526AWRegistration Pending · Shell Lake, WIRegistration pendingN526JMFaith-Full Family Finances Inc · Mount Vernon, OHN526MEMike Whiskey Echo LLC · Camden, DEN526VRR V Aviation LLC · Thatcher, AZN52715Echo Sierra 54 LLC · Hagerstown, MDN5271BTexas Department Of Public Safety · Austin, TXN5271FUnverfehrt David C · Ocala, FLN5275CRamaswamy Ashok · Clearwater Beach, FLN52766Krobkrua Tio LLC · Snowflake, AZN5276YPadlock Ranch Co · Ranchester, WYN527DKEci Staffing Solutions Inc · Stamford, CTN527DPNavair LLC · Mount Vernon, OHN527TBN527tb LLC · Missoula, MTN5283CRanchaero LLC · Houston, TX
Back to AD 71-13-01 R1