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.
N11SPState Of New York · Albany, NYN11TVHelicopters Inc · Cahokia, ILN120LACounty Of Los Angeles Fire Dept · Pacoima, CAN120LHHelilease LLC · Lewes, DEN1219WMoes Crop Dusting Service Inc · Marysville, CAN121BT206 Holdings LLC · Spanish Fork, UTN121LPPremier Rotors LLC · Saint Martinville, LAN122BTNorth Wind Aviation LLC · Cottage Grove, ORN122JLotus Aviation LLC · Boring, ORN123HPSouthwest Heliservices LLC · Mesa, AZN123NCNorth Carolina State Highway Patrol · Cary, NCN123RJR J Corman Railroad Co/Bardstown Line · Nicholasville, KYN123WFJk Aviation LLC · Kerman, CAN124AEAir Evac Ems Inc · O Fallon, MON124EHJbp Aviation LLC · Henderson, NVN125TAGm Leasing Company LLC · Broussard, LAN125WHWestwind Helicopters Inc · Santa Fe, TXN126SHKey West Helicopters LLC · Key West, FLN127APGm Leasing Co LLC · Broussard, LAN127JLBristow LLC · Lake Charles, LAN12AAAllsouth Aviation LLC · Buford, GAN12AEAir Evac Ems Inc · O Fallon, MON12ATCustom Cub LLC · Keizer, ORN12BQHelicopters Inc · Cahokia, ILN12CTCt Air LLC · Clovis, NMN12EWJetcopters LLC · Lewes, DEN12HXHelicopter Express LLC · Chamblee, GAN12JWRuffwood Inc · Atlanta, GAN130AEAir Evac Ems Inc · O Fallon, MON130BHObrien Helicopters Inc · Lehigh Acres, FLN130CCAirone Helicopters LLC · Slaughter, LAFirst renewal noticeN130JHRanger Aviation Leasing LLC · Wilmington, DEN131AEAtwood Aviation LLC · Pickerington, OHN131SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedN131WMWestwind Helicopters Inc · Santa Fe, TXN132AEAir Evac Ems Inc · O Fallon, MON132HNHealthnet Aeromedical Services Inc · Charleston, WVN1337KJsg Aviation LLC · Wilmington, DEN133AEAir Evac Ems Inc · O Fallon, MON133LAConsolidated Fire Protection · Pacoima, CAN134AEAir Evac Ems Inc · O Fallon, MON134AMAir Methods LLC · Greenwood Village, CON134MSSunny Sky LLC · Stacyville, IAN135AEDodson International Parts Inc · Rantoul, KSN135AMAir Methods LLC · Greenwood Village, CON135BREurotec Vertical Flight Solutions LLC · Eudora, KSN135BUMetro Aviation Inc · Shreveport, LAN135CJAir Methods LLC · Greenwood Village, CON135CMAir Methods LLC · Greenwood Village, CON135DHMetro Aviation Inc · Shreveport, LA
Back to AD 2011-25-01