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.
N44295Caribbean Aviation Lc · Miami, FLN4429FMc Leasing LLC · Delta, UTN4429XPearls Pilot LLC · Jefferson City, MON442APThree Mayhoods LLC · Bonita Springs, FLN442DZValiair Limited Company Trustee · Casper, WYN44328Riddle Bruce C · Franklin, NCN4434DAir Arctic Inc · Fairbanks, AKN44369T&B Aviation LLC · Rancho Cucamonga, CAN443HPMotorcarlease USA Inc · Miami Beach, FLN443WACentral Airlines Inc · Overland Park, KSN4445XRegistration Pending · Midlothian, TXRegistration pendingN44494N44494 LLC · Peachtree City, GAN444CACentral Airlines Inc · Leawood, KSN444CBCentral Airlines Inc · Overland Park, KSN444GW2.8 Gpa LLC · Dover, DEN444JKHodges Aviation LLC · Cleburne, TXN444MJMcfarlin Lucinda · Nacogdoches, TXN444NAPittman Deryl Trustee · Morgantown, INN444RMSky Taxi LLC · Fort Payne, ALN444TSUig Transport LLC · Raleigh, NCN444VStrock Gary · Annville, PAN444VMPrecise Flights LLC · Jensen Beach, FLN444VXStrock Gary L · Annville, PAN445FMAgee Mark L · Greenacres, WAN445MAPvl Development LLC · Nashville, TNN44601Talon Aero LLC · Bowling Green, OHN44661Family Flyer Six LLC · Columbus, INN44685Sundance Air Charter LLC · Portland, ORFirst renewal noticeN4468XHalf Nuts LLC · Boiling Springs, PAN446JCSaf Aviation LLC · Lakewood Ranch, FLN446NCKhk Management Services LLC · Norcross, GAN446RHN446rh LLC · Helena, MTN446SESouthern Aircraft Consultancy Inc Trustee · Casper, WYN44746Kline William D Trustee · Chesterfield, MON44755Argosy Venture Corp · Pagosa Springs, CON44783Family Eye Care Center LLC · Elkins, WVN447DLGlobal Control Systems Inc · Olathe, KSN447KCN447kc LLC · Mesa, AZN447LSSouthwest Aviation Enterprises · Haslet, TXN447SCN447sc LLC · Carmel, CAN447TThompson Systems Inc · Amana, IAN44813Olusanya Babajide A · Cherry Hill, NJN4483TWaterboy Aviation LLC · Richlandtown, PAN44851King Air Inc · Naknek, AKN4485XL & A Bennett Second Family Lp · Renton, WAN448AWeeke Aviation LLC · Kalispell, MTN448MAReynolds Roger David · Key West, FLN448STJames David W · Odessa, TXN448TWCanyon Aviation LLC · Glenwood Springs, CON4492Triego Inc · Dumas, TX
Back to AD 71-13-01 R1