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.
N217HPNs Air Leasing LLC · Wilmington, DEN242ADepartment Of Homeland Security · Washington, DCN243GCGranite Coast Mapping · Coronado, CAN244CPAircraft Trustee Services Inc Trustee · Dover, DEN245AMAir Methods LLC · Greenwood Village, CON253LFAir Methods LLC · Greenwood Village, CON255LFAir Methods LLC · Greenwood Village, CON255RMCgcpr LLC · Canovanas, PRN25740Arrow Aviation Company LLC · Broussard, LAN257AMAir Methods LLC · Greenwood Village, CON259AMAir Methods LLC · Greenwood Village, CON267AMAir Methods LLC · Greenwood Village, CON267RCBank Of Utah Trustee · Salt Lake City, UTN26HXNs Air Leasing LLC · Wilmington, DEN273AMAir Methods LLC · Greenwood Village, CON277FXFlexjet Vertical Lift LLC · Stratford, CTN278FXFlexjet Vertical Lift LLC · Stratford, CTN279AMAir Methods LLC · Greenwood Village, CON302SCUsaircraft Inc · Newark, DEN304MPMiami-Dade Sheriff'S Office · Doral, FLN305MPMiami-Dade Sheriff'S Office · Doral, FLN306LFAir Methods LLC · Greenwood Village, CON30EZHover Air LLC · Anchorage, AKFirst renewal noticeN312SDHarris County Sheriffs Office · Spring, TXN317AMAir Methods LLC · Greenwood Village, CON325AMAir Methods LLC · Greenwood Village, CON327VAAir Wolfpack LLC · Grand Rapids, MIN328CHAir Methods LLC · Greenwood Village, CON329AMAir Methods LLC · Greenwood Village, CON329TXTexas Department Of Public Safety · Austin, TXN332AMAir Methods LLC · Greenwood Village, CON335AMAir Methods LLC · Greenwood Village, COFirst renewal noticeN336AMAir Methods LLC · Greenwood Village, CON339AMAir Methods LLC · Greenwood Village, CON341AMAir Methods LLC · Greenwood Village, CON344AMFirst Citizens Bank & Trust Company · Morristown, NJN34HFHeliflite Shares LLC · Kearny, NJN34MBN1079a LLC · Missoula, MTN350AMAir Methods LLC · Greenwood Village, CON350DLSierra Group LLC · Bend, ORN350HQNs Air Leasing LLC · Wilmington, DEN350LFAir Methods LLC · Greenwood Village, CON350MPCity Of Memphis Police Department · Memphis, TNN350MVAir Methods LLC · Greenwood Village, CON350NCState Of North Carolina · Raleigh, NCN350TARoberts Aircraft LLC · Cheyenne, WYN350VRPrecision LLC · Mcminnville, ORN351CHSycan Corp DBA Sinton Helicopters · Paso Robles, CAN351HDT Scott Dunn Construction Inc · Phoenix, ORN352HDT Scott Dunn Construction Inc DBA · Phoenix, OR
Back to AD 2012-18-18