AD 2011-25-01
Registered aircraft · 2,822
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:2011-25-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:2011-25-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:2011-25-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:2011-25-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.
N197AAChem-Air Inc · Shreveport, LAN198HIndustrial Helicopters LLC · Lafayette, LAN198MAMarks Aviation Group LLC · Lafayette, LAFirst renewal noticeN19BHAbc Helicopters Inc · Jefferson, WIN19HXPremier Aircraft Services LLC · Bakersfield, CAN19NGNorgreen Aviation LLC · Kirkland, WAN1AKMeridian Investments LLC · Anchorage, AKN1MHIsaiah 40v31 LLC · Orlando, FLN1MJLittle Ranger LLC · Jackson, WYN1TNNorman Family Investments LLC · Greenville, TXN2009CMeridian Helicopters LLC · Broussard, LAN200HNAir Methods LLC · Greenwood Village, CON200HRSutter Air Inc · Los Banos, CAN200PCRincon Enterprises LLC · Helena, MTN200UPKmv Leasing LLC · Shreveport, LAN200VBVertical Vegetation Management LLC · Darlington, INN201PAAsa Security LLC · Anchorage, AKN201SMDemo Salvage Inc · Calais, MEN2020ROphthalmology Transport Inc · Opelousas, LAN202MHSouthern Utah University · Cedar City, UTN202PHCoastal Air Services Inc · Panama City, FLN202TPHeartland Aviation LLC · Ada, OKN20316Back Nine Aerial LLC · New Berlin, WIN2036FBell Textron Inc · Fort Worth, TXN203EHDsl Aviation LLC · Perham, MNN203HAHelo N203ha LLC · Richmond, VAN203PAD H Helicopter Inc DBA · Mcminnville, ORN2041XQbl Aviation LLC · Waco, TXN2043BL&R Investment Partners LLC · Wilmington, DEN204AVSan Juan Aviation LLC · Wilmington, DEN204SWybenga Aviation LLC · Twin Falls, IDN204USBlue Air 2 LLC · Miami, FLN205CPSouthern Helicopters Inc · Sunshine, LAN205EHSacramento Executive Helicopters Inc · Acampo, CAN205FCGm Leasing Co LLC · Broussard, LAN205GRCentral States Helicopters Inc · Wood River, NEN205PARidgeline Enterprises LLC · Twin Falls, IDN2060NScotts Helicopter Service Inc · Le Sueur, MNN2061JHillcrest Aircraft Co Inc · Lewiston, IDN2064SAgricultural Air Services LLC · Jupiter, FLN20683Cascade Helicopters LLC · Canby, ORN2068AAerial Control Inc · Brentwood, CAN206ACAirconnor LLC · Livingston, MTN206AJVertical Air LLC · Wilmington, DEN206APInstant Security Services Inc · Wilmington, DEN206BBNixon Helicopters LLC · Mentone, CAN206BESummit Helicopters Inc · Salem, VAN206BGMerced County Sherrifs Office · Merced, CAN206BMWg Northland LLC · Seeley Lake, MTN206BWWesson William D · Lincoln, AL
Back to AD 2011-25-01