AD 2000-16-05
Registered aircraft · 428
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:2000-16-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05')
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:2000-16-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-16-05') 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.
N313BAR & R Testing Inc · Watertown, SDN322CPPaul William D · Cadillac, MIN330JBHavens Aviation LLC · Blacklick, OHN330PDCity Of Oakland · Oakland, CAN330THHuff Jon L · Corning, NYN333GJOliver Enterprises LLC · Newalla, OKN340DCItb Sokolowski LLC · Lewes, DEN3417HGc Monitoring Inc · Bellevue, WAN345MHKinzie Industries Inc · Erie, COExpired dealerN34LBVenture Helicopters LLC · West Lafayette, INN355SDBofus Aviation LLC · Helena, MTN357PDBrown Helicopter Inc · Pensacola, FLN360JFCt Grain Systems LLC · Lewisburg, KYN361BHDixon Thomas R · Lance Creek, WYN3624TMaxess Inc · Thonotosassa, FLN3625TBlade Runners Chopper LLC · Sunbury, OHN3626BBarney Thomas E · Cresco, PAN366GCHavens Aviation LLC · Blacklick, OHN367RWSpies Robert Charles Sr · Kingman, AZN37750Bacon Gregory · Prairie Home, MON380MCVeturis David L · Lake Forest, CAN385TATomlinson Aviation Inc · Ormond Beach, FLN388HFEchelon Right LLC · Springfield, TNN38ABJerry Lay Aviation LLC · Minonk, ILN3947CHelocraft Holding Co Inc · Pembroke Pines, FLN396CPAir 1 LLC · Newark, DEN3TFHelicopter Accessory Service East · Pensacola, FLN406CSSiderius Construction Llp · Kalispell, MTN411HUDodson International Parts Inc · Rantoul, KSN411JCFlying Z Ranch LLC · Douglas, WYN413LHRatcliff Dustin Matthew · Saltville, VAN41THLammers Ross L · Cumming, GAN426GGulf Coast Helicopters Inc · Pearland, TXN4276REchols Mark R · Diana, TXN434STSchweizer Rsg LLC · Fort Worth, TXN444EDunker Quinn E · Morse Bluff, NEN451JRFathom Aviation LLC · Burley, WAN451MCAero-Tech Helicopters LLC · Kingstree, SCN47SDWampler William C · Canton, TXN48155Classic Rotors Museum · Ramona, CAN4853STurley Gregory D · Pell City, ALN49WGGarlock Walter G · Oconomowoc, WIN5001FReynolds Darryl G · Wills Point, TXN50045Drive A Tank Inc · Kasota, MNN500HSDaniels Richard L · Bow, WAN5015VFoos LLC · Vancouver, WAN503JNTailwind Investments LLC · Zeeland, MIN503QDSchroth Charles D · Gustavus, AKN504JNPolarblast LLC · Bellefonte, PAN511BHParis Air Inc · Vero Beach, FL
Back to AD 2000-16-05