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.
N681ASRba LLC · Kimberly, IDN694BBO307 LLC · Surprise, AZN695HSMocha LLC · Tucson, AZN6MVWing And Rotor Transportation Holdings LLC · Morristown, NJN6UXHelicopters Inc · Cahokia, ILN708PDEast Bay Regional Park District · Livermore, CAN709PPhi Health LLC · Tempe, AZN717CLR S Losee Helicopter Lc · Orem, UTN718PPhi Aviation LLC · Lafayette, LAN723PVN23pv LLC · Redondo Beach, CAN724PHPhi Aviation LLC · Lafayette, LAN725LLMilton S Hershey Medical Center · Hershey, PAN725PPhi Aviation LLC · Lafayette, LAN728AMAir Methods LLC · Greenwood Village, CON72EHHelinet Aviation Services LLC · Van Nuys, CAN736AMAir Methods LLC · Greenwood Village, CON745PPhi Aviation LLC · Lafayette, LAN751AMUS Department Of Homeland Security · Washington, DCN752AMUS Department Of Homeland Security · Washington, DCN753AMUS Department Of Homeland Security · Washington, DCN753PPhi Health LLC · Tempe, AZN754AMUS Department Of Homeland Security · Washington, DCN754LArrow Aviation Co LLC · Broussard, LAN755AMUS Department Of Homeland Security · Washington, DCN759MMTrevor Corp DBA · Grayslake, ILN759PPhi Health LLC · Tempe, AZN764AMNorth Flight Aero Med · Grand Rapids, MIN768AMSpectrum Health Hospitals · Grand Rapids, MIN769PPhi Aviation LLC · Lafayette, LAN76HHHallecopter LLC · Wilmington, DEN76ZAN76za LLC · New York, NYN772PPhi Aviation LLC · Lafayette, LAN773BGBristow LLC · Lake Charles, LAN773PAKaibab LLC · Kirkland, WAN773XGooseneck Inc · Heber City, UTN777CTVertical Corp · Kalispell, MTN779GCGranite Coast Mapping · Coronado, CAN779PAXebec LLC · Kirkland, WAN780GSAir Methods LLC · Greenwood Village, CON781PPhi Health LLC · Tempe, AZFirst renewal noticeN781RLGm Leasing Company LLC · Broussard, LAN782RLGm Leasing Company LLC · Broussard, LAN783RLGm Leasing Company LLC · Broussard, LAN784PAKaibab LLC · Kirkland, WAN784RLGm Leasing Company LLC · Broussard, LAN785PSale Reported · Robert, LASale reported, canceledN785RLGm Leasing Company LLC · Broussard, LAN786PAXebec LLC · Kirkland, WAN786RLGm Leasing Company LLC · Broussard, LAN787RLGm Leasing Company LLC · Broussard, LA
Back to AD 2012-18-18