AD 75-16-10
Registered aircraft · 2,695
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:75-16-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10')
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:75-16-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-10') 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.
N12KSWalton Cheryl H · Indianapolis, INN12MTRegistration Pending · Mount Vernon, IARegistration pendingN12WLLauterbach Christian · Carmel, CAN1302ZPlaisier Matthew · Lafayette, TNN1305ZReynolds James Patrick · Lebanon, TNN1307Brian Michael L · Greensboro, NCN1309ZReady Aim Flyer LLC · New Castle, DEN1311ZJprg Aviation Inc · Orlando, FLN13131Premier Capital Enterprises LLC · Hurricane, UTN1315ZRiesbeck Randall C · Waynesville, OHN131FHappy Star LLC · Baxley, GAN131TWBaron N131tw LLC · Wilmette, ILN132BMds Flying LLC · Deephaven, MNN132TWRc Flyers LLC · Wilmington, DEN1332ZUp And Up Aviation LLC · Spring, TXN1333Beech Nut Flyers LLC · San Diego, CAN1339ZSmith Derek D · Brooks, GAN133MRPrecision Aero LLC · Wilmington, DEN1340ZLogue Andrew Douglas Trustee · Port Saint Lucie, FLN1341ZAustin Bill DBA · Sparta, TNN134CBGlobal Coin Logistics LLC · Lexington, KYN134FLift Enterprises LLC · Lynn Haven, FLN1350SLo Pilato Family Flights Inc · Coral Gables, FLN1351ZErickson David R · West Point, UTN1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeN135FBSky West Aviation Inc Trustee · Albuquerque, NMN135KAcord Aviation Co L L C · Chandler, OKN1365ZSkans David K · Henderson, NVN1366ZPfetsch Mitchell R · Daggett, CAN1373ZHoitt Edward D Jr · Deerfield, NHN1377ZCoen Brady · Wiley, CON137FSmith Nathan · Citra, FLN137JPRitec LLC · Sandown, NHN1385ZWilson Tommy V · Greenleaf, IDN138QKyff Jeffrey V · Traverse City, MIN139PTCroley John T Jr · Fitzgerald, GAN139QMoles Timothy E · New Cumberland, WVN13AKTailwinds Inc · Toms River, NJN13HMN13hm LLC · Punta Gorda, FLN13MKLjh Consulting Services LLC · Greenleaf, IDN13TWSouthern Aerial Service LLC · Douglas, GAN1403G1403g LLC · Wheat Ridge, CON1409GAir Care Leasing LLC · Lamar, CON140SGta Air Inc · Addison, TXN140WLMorning Air LLC · Indian Rocks Beach, FLN141CLFulbright Charles M · Toccoa, GAN141PCCleggs Termite And Pest Control · Morehead City, NCN1420GRamsey April Dawn · Saraland, ALN142DRHj & L Air LLC · Sacramento, CAN142FGall Peter · Morgantown, WV
Back to AD 75-16-10