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.
N1404WPendley Rory G · Torrance, CAN140HLGm Leasing Company LLC · Broussard, LAN1416Gm Leasing Company LLC · Broussard, LAN141APGm Leasing Co LLC · Broussard, LAN141FAOrange County Fire Authority · Irvine, CAN142DPMarks Lloyd · Lafayette, LAN142MAMinuteman Aviation Inc · Missoula, MTN1431WC-Pan Aero LLC · Stratford, CTN1435WFarwest Aviation LLC · Billings, MTN143HBank Of Utah Trustee · Salt Lake City, UTN143MHMetro Aviation Inc · Shreveport, LAN143PHWestern USA Solutions Inc · Kodiak, AKN144ATBell Textron Inc · Fort Worth, TXN144BHAbc Helicopters Inc · Jefferson, WIN144MAMinuteman Aviation Inc · Missoula, MTN144TVAir Flite Inc · Shawnee, OKN145BHBell Textron Inc · Fort Worth, TXN145LTLt Aviation LLC · Louisa, KYN146SHScott'S Helicopter Services · Le Sueur, MNN146SPSamaritan'S Purse · Boone, NCN147AGTop Gun Precision Ag LLC · Skidmore, TXN147CBJab II LLC · Mobile, ALN14837Oscar Aerial Spraying LLC · Grady, OKN148AWAircraft Trustee Services Inc Trustee · Dover, DEN148BHBell Textron Inc · Fort Worth, TXN148KYCommonwealth Of Kentucky · Frankfort, KYN149PDAdministracion De Los Servicios Generales · San Juan, PRN14HXHelicopter Express LLC · Chamblee, GAN14LACounty Of Los Angeles · Pacoima, CAN14SJAlternative Energies Corp · Beaver Island, MIN14ZBlack Labs LLC · Anaconda, MTN150AMAir Methods LLC · Greenwood Village, CON150F11 11 Enterprises LLC · San German, PRN150HHCascade Airways LLC · Jefferson, ORN1510LCity Of Dallas · Dallas, TXN1511LCity Of Dallas · Dallas, TXN152AMAir Methods LLC · Greenwood Village, CON152CAChem Air LLC · Shreveport, LAN153PAGm Leasing Company LLC · Broussard, LAN155DBSalmon River Helicopters Inc · Riggins, IDN155TVU S Helicopters Inc · Marshville, NCN156BHBell Textron Inc · Fort Worth, TXN156CAChem-Air LLC · Shreveport, LAN156HMSky West Aviation Inc Trustee · Albuquerque, NMN156MHMansfield Heliflight Inc · Milton, VTN157BHBell Textron Inc · Fort Worth, TXN157PAPatriot Aviation Inc · Greenville, DEN157SJNorth Wind Aviation LLC · Cottage Grove, ORN158AMAir Methods LLC · Greenwood Village, CON158BCMetro Aviation Inc · Shreveport, LA
Back to AD 2011-25-01