AD 2012-18-18
Registered aircraft · 400
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:2012-18-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-18-18')
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:2012-18-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-18-18') 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.
N401MFDare County · Manteo, NCN401RMRegional Air Medical Services Inc. · Jasper, ALN402JCJefferson County Sheriffs Office · Birmingham, ALN40WHGm Leasing Co LLC · Broussard, LAN411LHApex Aeronautical · San Antonio, TXN411MBVertical Corp · Kalispell, MTN418TYAir Methods LLC · Greenwood Village, CON4204Air Methods LLC · Greenwood Village, CON425AMFirst-Citizens Bank & Trust Co · Morristown, NJN4282Air Methods LLC · Greenwood Village, CON440RMRegional Air Medical Services Inc · Jasper, ALN4497YAir Methods LLC · Greenwood Village, CON44DSDs Air II LLC · Carrollton, VAN4514RArrow Aviation Company LLC · Broussard, LAN454WHGm Leasing Company LLC · Broussard, LAN455GFAdventaire LLC · Minot, NDN456AEEurotec Vertical Flight Solutions LLC · Eudora, KSN464RMRegional Air Medical Services Inc · Jasper, ALN47WHInternational Air Services Inc Trustee · Carson City, NVN484FAFreedom Aviation LLC · Helena, MTN490HAir Methods LLC · Greenwood Village, CON498AEPhi Health LLC · Tempe, AZN4PAPylon Aviation Services LLC · Chandler, AZN500KVPortland General Electric Co · Portland, ORN506LFAir Methods LLC · Greenwood Village, CON507AMAir Methods LLC · Greenwood Village, CON508AMAir Methods LLC · Greenwood Village, CON530HBas Part Sales LLC · Greeley, CON533AMAir Methods LLC · Greenwood Village, CON538FSBayou Skys LLC · Wilmington, DEN54178Air Methods LLC · Greenwood Village, CON54315Discovery Helicopters LLC · Las Vegas, NVN544AMAir Methods LLC · Greenwood Village, CON544ASApexheli Oregon Inc · Florence, ORN545HFHaynes Aviation LLC · Wetumpka, ALN547WMBristow LLC · Lake Charles, LAN551AMAir Methods LLC · Greenwood Village, CON555VTArlo Air LLC · Columbus, OHN556SDHarris County Sheriffs Office · Houston, TXN55GJCfa Holdings Inc · Knoxville, TNN574AMAir Methods LLC · Greenwood Village, CON577LFAir Methods LLC · Greenwood Village, CON585AEPhi Health LLC · Tempe, AZN590AEPhi Health LLC · Tempe, AZN601TATrans Aero LLC · Cheyenne, WYN614JCKnight Helo LLC · Wilmington, DEN617GCGranite Coast Mapping · Coronado, CAN629AMAir Methods LLC · Greenwood Village, CON62ARBird Dog Aircraft LLC · Billings, MTN631SBSan Bernardino County Sheriffs Dept · San Bernardino, CA
Back to AD 2012-18-18