AD 76-07-07
Registered aircraft · 496
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:76-07-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-07-07')
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:76-07-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-07-07') 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.
N251JLGolden Eagle 421 LLC · Alsip, ILN260RAUpward Aviation LLC · Tulsa, OKN262MCAerospace Trust Management LLC Trustee · Wilmington, DEN264DCAirdvm LLC · Rcho Sta Marg, CAN26533Txoperation LLC · Fort Scott, KSN26560Rockslide Analytics Inc · Livermore, CAN2657GB & K Leasing Inc · Nantucket, MAN2657NLoreto Aviation LLC · Wahoo, NEN26588Golden Aero LLC · Tarpon Springs, FLN2658ZVirtue Genetics LLC · Cedar Rapids, IAN265RGHerron Aviation Group LLC · Dexter, MIN2660UUnited Front Holdings LLC · Laguna Hills, CAN2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN268JBIn Tune Entertainment Inc · Scottsdale, AZN269CGold Beach Lumber Yard Inc · Brookings, ORN26GDGragert Richard Trustee · Katy, TXN26HEMccreery Aviation Co Inc · Mcallen, TXN26LFForte Paul · West Bloomfield, MIN274MBAdams Aviation Services Inc Trustee · Wilmington, DEN284DMDreamworks Aviation LLC · Palm Beach Gardens, FLN28RHNational Airplane Sales & Leasing Corp · Lima, OHN28WDOptio Air LLC · Moore, OKN291ANKb Flies LLC · Amarillo, TXN299GBHoodoo LLC · Missoula, MTN29XXMustang Aeronautics LLC · Chandler, AZN2JAJadair International Inc · Port Washington, WIN2LYMagnolia Air LLC · Starkville, MSN300BRMach Tuck Aero Group LLC · Elkhorn, NEN307FMNorris Aviation LLC · Mansfield, TXN30LTJuans Adios LLC · Newark, DEN30PTGas Aviation LLC · Decatur, TNN311BC311bc LLC · Channelview, TXN311CASouthern Wings LLC · Shreveport, LAN311JHHuaco Aviation LLC · Waco, TXN316WCEagle Aeronautics LLC · Chicago, ILN31CLg & Gs Holdings LLC · Middletown, DEN31CULovaas Jean H Trustee · Crescent City, CAN31MMPence Air LLC · Edinburg, VAN321CEGreen Eggs And Ham Aero LLC · Helena, MTN334NCarter-Muthana Aero LLC · Bakersfield, CAN33UWPadf LLC · Fort Collins, CON341RBRomeo Bravo LLC · Thompson, MON342RCHyland'S Pharmacy LLC · Wheeler, TXN344TCInternational Air Services Inc Trustee · Carson City, NVN34ADPremiere Aviation Inc · Concord, CAN34AGJ D Aviation Leasing LLC · Mundelein, ILN365FDci Air LLC · Dodge City, KSN369RKKrum Force 1 LLC · Wichita, KSN369RMRothschild Jonathan Trustee · Tucson, AZN371SBN333bc LLC · Franktown, CO
Back to AD 76-07-07