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.
N352RNs Air Leasing LLC · Wilmington, DEN353AMAir Methods LLC · Greenwood Village, CON353CEAviation Advantage Inc · Tabor City, NCN353FBNs Air Leasing LLC · Wilmington, DEN353MHPathfinder Leasing LLC · Anchorage, AKN353PPhi Health LLC · Tempe, AZN353SHSycan Corp DBA · Paso Robles, CAN354CFRegistration Pending · Greenwood Village, CORegistration pendingN354PPhi Health LLC · Tempe, AZN354SHSycan Corp DBA · Paso Robles, CAN355CFAir Methods LLC · Greenwood Village, CON355JSMinerd Holdings LLC · Chicago, ILN357PAPathfinder Leasing LLC · Anchorage, AKN358AMAir Methods LLC · Greenwood Village, CON358TVTiny Bubbles Aviation Inc · Pacoima, CAN359FBPhoenix Police Department · Phoenix, AZN359PANs Air Leasing LLC · Wilmington, DEN35HFHeliflite Shares LLC · Kearny, NJN36HFHeliflite Shares LLC · Kearny, NJN370NCState Of North Carolina · Raleigh, NCN375AHBank Of Utah Trustee · Salt Lake City, UTN376AHBank Of Utah Trustee · Salt Lake City, UTN376WHGm Leasing Company LLC · Broussard, LAN382AMAir Methods LLC · Greenwood Village, CON3831Air Methods LLC · Greenwood Village, CON383AKAlpha Aviation LLC · Anchorage, AKN385AKAlpha Aviation LLC · Anchorage, AKN387AK387ak LLC · Anchorage, AKN388AMFirst-Citizens Bank & Trust Co · Morristown, NJN38HFHeliflite Shares LLC · Kearny, NJN390AMAir Methods LLC · Greenwood Village, CON391LGAir Methods LLC · Greenwood Village, CON3931ADepartment Of Homeland Security · Washington, DCN3933ADepartment Of Homeland Security · Washington, DCN3934ADepartment Of Homeland Security · Washington, DCN3935ADepartment Of Homeland Security · Washington, DCN3937ADepartment Of Homeland Security · Washington, DCN3938ADepartment Of Homeland Security · Washington, DCN3939ADept Of Homeland Security Customs & Border · Washington, DCN3940ADepartment Of Homeland Security · Washington, DCN3944ADepartment Of Homeland Security · Washington, DCN3946ADepartment Of Homeland Security · Washington, DCN3947ADepartment Of Homeland Security · Washington, DCN3949ADepartment Of Homeland Security · Washington, DCN3951AUS Department Of Homeland Security · Washington, DCN3953AUS Department Of Homeland Security · Washington, DCN3972AUS Department Of Homeland Security · Washington, DCN3983AUS Department Of Homeland Security · Washington, DCN39EWTuckamore Aviation Corp · Hudson, MAN39HFHeliflite Shares LLC · Kearny, NJ
Back to AD 2012-18-18