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.
N23MCFilm Fliers Inc · Orlando, FLN23MMAmerica Atlantic Aviation Inc · Stuart, FLN23SKPlainsman Aviation LLC · Kalispell, MTN23VGPainted Horse Holding LLC · New Town, NDN23VMOrange Skies LLC · Great Falls, VAN23WBQualitair LLC Trustee · MichelstadtN2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKN2405MFree Flyers Avionics Inc · Kerkhoven, MNN240CPCivil Air Patrol · Maxwell Afb, ALN240CSSem Assets LLC · Carrollton, TXN240JBMarking Kevin J · Omaha, NEN240PSN240ps LLC · Mesa, AZN240TBN54za LLC · Houston, TXN24129Ssi Aviation Group LLC · Eagle, IDN2413ACotner Jeffry J · Houston, TXN2413M2021 Liberty Air LLC · Santa Rosa, CAN2416MSun South Aviation LLC · Wilmington, DEN24177Fever Five LLC · Salem, ORN241DGJust Plane Fun · Santa Barbara, CAN241GTBroshchan Ruslan A · Jackson, MSN241KRMako Offshore Exploration Inc · Pagosa Springs, CON241MPGv Air Inc · Medford, ORN241PBTranstek International Inc · Deerfield, ILN241WFInternational Air Services Inc Trustee · Carson City, NVN2422UDennissan LLC · Noble, OKN2423CGriffin Aviation LLC · Ventura, CAFirst renewal noticeN24240Vantage Asset Management LLC · Edinburg, TXN2424PMize Craig · Cerulean, KYN2426BDBA Investments LLC · Eldon, MON2427BKbtp Holdings LLC · Sewickley, PAN24287J B C Development LLC · Evans, GAN24289Collen Rodney J · Tacoma, WAN2428JWilliams Shirley A Trustee · Alpine, TXN24293Digitalev LLC · Westminster, CON2429QKaufer Peter H · Tucson, AZN242KFTio Pedro P · Miami, FLN242MJWch/Lgs Sky Ventures LLC · Littleton, NCN242PMPlanebiz LLC · Fort Walton Beach, FLN242RKBas Part Sales LLC · Greeley, CON242TC182 Flight Corp · Bronx, NYN242TJMagee Timothy I · Gulfport, MSN242WBUnited States Department Of Interior · Boise, IDN242WFN242wf LLC · Wilmington, DEN24301Pacific Coast Cycle Corp · Kings Beach, CAN2430QBeavercat Air LLC · Myrtle Point, ORN2431XDvirnak Paul · Hesperus, CON24337Dunn Craig M · Sarasota, FLN2433UEddleman David Baggett · Mclean, VAN2439DN2439d LLC · Oklahoma City, OKN2439RAdams Aviation Services Inc Trustee · Wilmington, DE
Back to AD 71-13-01 R1