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.
N108DRParamount International Inc · Millville, NJN108GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN108LHHelilease LLC · Lewes, DEN108SCCounty Of Sonoma · Santa Rosa, CAN108VUAir Methods LLC · Greenwood Village, CON108WWeyerhaeuser Nr Co · Eugene, ORN109BCBroward County Sheriffs Office · Fort Lauderdale, FLN109DXSunwest Construction Enterprises Inc · Tarpon Springs, FLN109RASunny Sky LLC · Stacyville, IAN109USU S Helicopters Inc · Marshville, NCN10AJEl Aero Services LLC · Elko, NVN10KXWhirly Leasing Inc · Richvale, CAN10LESlws LLC · Missoula, MTN10MSKas Enterprises LLC · Lewes, DEN10SPState Of Kentucky · Frankfort, KYN10TVHelicopters Inc · Cahokia, ILN10XVHelicopters Inc · Wilmington, DEN110DJLife Flight Network LLC · Aurora, ORN110LAConsolidated Fire Protection · Pacoima, CAN110LTLt Aviation LLC · Louisa, KYN110WGMeshoppen Air LLC · Tunkhannock, PAN111BVOceanside Vertical Express LLC · Canaan, NYN111GHGuardian Helicopters Inc · Fillmore, CAN111HFPlane Fun Inc Tr Trustee · Snellville, GAN111PMTri Rotor Spray And Chemical · Ulysses, KSN111SPState Of Michigan · Lansing, MIN112EPMarks Aviation Group LLC · Lafayette, LAN112LPRanger Aviation Leasing LLC · Wilmington, DEN112MTReach Air Medical Services LLC · Santa Rosa, CAN113AEAir Evac Ems Inc · O Fallon, MON113AMAir Methods LLC · Greenwood Village, CON113MTMed-Trans Corp · Denton, TXN114SFN179sf LLC · Chandler, AZN114WHWestwind Helicopters Inc · Santa Fe, TXN1158BAir Gov 1 LLC · Rome, NYN115SFRedding Air Service Inc · Redding, CAN1170Gm Leasing Co LLC · Broussard, LAN1171Agricultural Air Services LLC · Jupiter, FLN117HKSettan Corp · Goleta, CAN117PCBank Of Utah Trustee · Salt Lake City, UTN117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedN118AEAir Evac Ems Inc · O Fallon, MON118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN118SPMinnesota State Patrol · Saint Paul, MNN118TVInterstate Helicopter Inc · Bethany, OKN119AEAir Evac Ems Inc · O Fallon, MON119MFMercy Flights Inc · Medford, ORN119SPState Of Minnesota · Saint Paul, MNN11FHD H Helicopter Inc DBA · Sauget, ILN11PPUS Dept Of The Interior · Boise, ID
Back to AD 2011-25-01