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.
N43451Redwood Air LLC · Roanoke, TXN43471Stewart Greg · Niwot, CON434BBElgin Engineering LLC · Arlington, TXN43527Ball Fred E · College Place, WAN435CKHycas LLC · Bountiful, UTN435HPOne2one LLC · Westminster, CAN43618Ferrandi Pierre · Phoenix, AZN4361KFour Way Aviation Inc · Spring, TXN4362TYost Jim · Flora, INN4363UInternational Air Services Inc Trustee · Carson City, NVN4365WSolomon Mark Trustee · Wilmington, DEN4367CGoemmer Land & Livestock LLC · Bartlesville, OKN436MAJjj Holdings LLC · Helena, MTN4370FRmr Inc · Exeter, CAN4371FSpongberg Paul F · Petaluma, CAN4371TBlevins John · Huntsville, ALN4371XBaptist Mid Missions · Cleveland, OHN43728Airtrans LLC · Southport, NCN4375QMolder Steven H · Middlebury, CTN4376VLetzig Farms Inc · Richmond, MON437CPCivil Air Patrol · Maxwell Afb, ALN437HMNby Productions · Bristow, VAN437JWMj Product Sale Inc · Cape Coral, FLN437WBLuscombe Gene A · Sherman, TXN43838Rodelsperger Robert · Charleston, SCN4383DFlying A Charters LLC · Wilmington, DEN4384SM&S Aviation LLC · Lebanon, MON4384XPrecision Aviation Partners LLC · Elko, NVN4385FFord Matthew · Glendale, AZN4396DBass Aviation LLC · Lewes, DEN43977Air Kraft Spraying Inc · Timber Lake, SDN43998Tailwind Aviation LLC · Royersford, PAN43CCWpb Pilot Service LLC · West Palm Beach, FLN43HBConefry Michael A · Belle Chasse, LAN43MZN9fx LLC · Columbus, MTN43RDMerrell Robert W Trustee · Boulder City, NVN43TLT M L Aircraft Inc · Narrowsburg, NYN43TRMeichelle Enterprises Inc · Santa Barbara, CAN43VBGv Air Inc · Medford, ORN4403TTyrrells Trails LLC · Fairbanks, AKN44087Little Island Roofing · Stuart, FLN440GTOlufsen Niels · Lakeway, TXN440MGSkyclub Aviation LLC · Wilson, NCN4418TRankin Kevin K · Vandalia, OHN441CPCivil Air Patrol · Maxwell Afb, ALN441HPMotorcarlease USA Inc · Miami Beach, FLN4420WOdonata LLC · Lewiston, IDN4425TBooth Aviation LLC · Fort Worth, TXN4426YR & S Enterprises · Fort Wayne, INN4428LAltenpohl LLC · High Point, NC
Back to AD 71-13-01 R1