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.
N57830Mid Continent Aircraft Corp · Hayti, MON57832Sherer Robert O · Hayes, SDN57846Boardman Air Services LLC · Henderson, NEN57859Airmotive Service LLC · Brigham City, UTN5787YMarr Steven K · Saint Charles, MON5788Knot Speed Ltd · Wilmington, DEN57882Dakota Air Spray LLC · Huron, SDN57886Bernstein Timothy D · Faith, SDN578WYBridger Aviation Services LLC · Belgrade, MTN5797YAce Tomato Co LLC · Daytona Beach, FLN579HFNorthstar Voyager Corp · Lewes, DEN579TTFairmont Aviation Aircraft Transport&Leasing Coinc · Panama CityN57BHBester Eric M · Shelby, NCN57BPB&C Property Group LLC · Plymouth, MIN57DTRegistered aircraftN57GPFoncho Corp · San Juan, PRN57JJRegistration Pending · Kewaskum, WIRegistration pendingN57KVBird Nest Aviation LLC · Sheldon, IAN57LBTellum Aviation Services LLC · Encinitas, CAN57MRTarriance LLC · Minnetonka, MNN57TFHighernet LLC · Antioch, CAN57WBBig Red Spring LLC · Fernandina Beach, FLN57XPBobcat Aviation LLC · Pretty Prairie, KSN5806YDan Howard Aircraft Sales LLC · Tulsa, OKN580CPCivil Air Patrol · Maxwell Afb, ALN580MMRoriz Joao · Oak Bluffs, MAN580SPWatag Corp Trustee · Wilmington, DEN5818YWells John R · Gonzales, TXN581RVKurtz Andrew · Boise, IDN581SGOetting William C · Midland, ORN5824YDonahue Sean M · Fort Lauderdale, FLN5825YTalmage John R · Kalispell, MTN5829DCounty Of Henrico Va · Henrico, VAN582CPCivil Air Patrol · Maxwell Afb, ALN5832NWitherington III William A · Newnan, GAN5832VPowless Robert A · Tierra Verde, FLN583EDEast Demarco Aviation LLC · Dallas, TXN5847YC&C Aviation LLC · Amarillo, TXN5848VSheffield David A · Silsbee, TXN584LQAir Shares LLC · Casper, WYN5854FBravo Sierra LLC · Middletown, DEN585MMN585mm Inc Trustee · Wilmington, DEN5867PWickenheiser Kevin John · Detroit, MIN5868VSiefken Arnold G · Jamestown, NDN586JCAlcyone Trust Corp Trustee · Wichita, KSN586MCJoselt Air LLC · Lithonia, GAN586TMReimer Michelle A · Shady Shores, TXN5870VHagerstown Regional Aero Club · Dallastown, PAN5880KCjc LLC · Syracuse, UTN5887YAlmost There Air LLC · Daytona Beach, FL
Back to AD 71-13-01 R1