AD 75-06-01
Registered aircraft · 2,832
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-06-01')
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-06-01')
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-06-01') 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-06-01') 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.
N336KTBlue Sky Worldwide LLC · Wilmington, DEN336RKBridger Aerospace Group Holdings LLC · Belgrade, MTN337GTFl-337 LLC · Redondo Beach, CAN338MCMissouri Department Of Conservation · Jefferson City, MON338SBSwitchback Aviation LLC · Cody, WYN339GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN339KAChenango Aviation LLC · Dallas, TXN33FGFlightline Group Inc · Tallahassee, FLN33HGMontana Aircraft Trust Inc Trustee · Bozeman, MTN33KCCarvair LLC · Salem, ORN33MCTwin Rivers Aircraft LLC · Sebastopol, CAN33VACommonwealth Of Virginia · North Chesterfield, VAN3407GRedditt Air Service Inc · Cleveland, MSN342THHill Thomas D · Parma, IDN343KTRustair Inc · Anchorage, AKN343RRAircraft Holding Solutions LLC Trustee · Newark, DEN344CSTransport Company LLC · Colorado Springs, CON345CKCklass Transport Inc · Chula Vista, CAN346BALwcr Transportation Inc · Minot, NDN346TMDierking Jason Michael · Storm Lake, IAN349WTPcw Air LLC · Mystic, CTN34ARoyal Air Freight Inc · Waterford, MIN34GXPinpoint Logistics LLC · Cambridge, NEN34HAHarper Aerospace LLC · Murfreesboro, TNN34HGUnited States Government · Fort Belvoir, VAN34LTPaper Boys LLC · Dover, DEN34RZUas Transervices Inc · Boca Raton, FLN350ABGolden Eagle One LLC · Garden City, KSN350BBRtd Air LLC · Hernando, MSN350BDParrot Air LLC · Corpus Christi, TXN350CFClemens Aviation LLC · Wichita, KSN350DRDeroyal Industries Inc · Powell, TNN350GACsc Delaware Trust Co Trustee · Wilmington, DEN350GLWipaire Inc · South Saint Paul, MNN350HCChildress Holdings LLC · Wilmington, DEN350KABigups Aviation 011 LLC · Van Nuys, CAN350KDHerr Daniel Rhyne · Murray Hill, NJN350KSSedgwick County · Wichita, KSN350KVWilmington Trust Co Trustee · Wilmington, DEN350MZClemens Aviation LLC · Wichita, KSN350TFLamb Aviation LLC · Perris, CAN350VMHawk Aviation II LLC · Farmington Hills, MIN351DYWilmington Trust Co Trustee · Wilmington, DEN351GFJ W Venture Aviation LLC · Concord, NCN351LRLr Leasing Inc · Carson City, NVN351MPMackie James Robert · Cookeville, TNN351SAGuardian Flight LLC · Lewisville, TXN351TATrans Executive Airlines Of Hawaii Inc · Honolulu, HIN352CLMinam River Ranch LLC · Portland, ORN352CMSky West Aviation Inc Trustee · Albuquerque, NM
Back to AD 75-06-01