AD 2012-17-03
Registered aircraft · 920
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-17-03')
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-17-03')
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-17-03') 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-17-03') 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.
N36TVUS Helicopters Inc · Marshville, NCN370HPOklahoma Department Of Public Safety · Norman, OKN370NCState Of North Carolina · Raleigh, NCN370SRDepartment Of Homeland Security · Washington, DCN375MBMh22 LLC · Minotola, NJN377GRAirbus Helicopters Inc · Grand Prairie, TXN381AKAlpha Aviation LLC · Anchorage, AKN381ZDepartment Of Homeland Security · Washington, DCN382AKAlpha Aviation LLC · Anchorage, AKN382BMCity Of San Antonio · San Antonio, TXN382PPhi Health LLC · Tempe, AZN3831Air Methods LLC · Greenwood Village, CON383AKAlpha Aviation LLC · Anchorage, AKN384AKAlpha Aviation LLC · Anchorage, AKN384PPhi Health LLC · Tempe, AZN385AKAlpha Aviation LLC · Anchorage, AKN386AKAlpha Aviation LLC · Anchorage, AKN386PPhi Health LLC · Tempe, AZN387AK387ak LLC · Anchorage, AKN389PPhi Health LLC · Tempe, AZN38HXHelicopter Express LLC · Chamblee, GAN390NSNorthstar Trekking LLC · Juneau, AKN391LGAir Methods LLC · Greenwood Village, CON391NSNorthstar Trekking LLC · Juneau, AKN391PPhi Health LLC · Tempe, AZN392HSIkarus Aviation LLC · West Jordan, UTN392NSNorthstar Trekking LLC · Juneau, AKN392PPhi Health LLC · Tempe, AZN3931ADepartment 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, DCN393NSNorth Star Trekking LLC · Juneau, AKN393PPhi Health LLC · Tempe, AZN3940ADepartment Of Homeland Security · Washington, DCN3944ADepartment Of Homeland Security · Washington, DCN3946ADepartment Of Homeland Security · Washington, DCN3947ADepartment Of Homeland Security · Washington, DCN3949ADepartment Of Homeland Security · Washington, DCN394NSNorthstar Trekking · Juneau, AKN394PPhi Health LLC · Tempe, AZN3951AUS Department Of Homeland Security · Washington, DCN3953AUS Department Of Homeland Security · Washington, DCN3972AUS Department Of Homeland Security · Washington, DCN397NSNorthstar Trekking LLC · Juneau, AKN397PPhi Health LLC · Tempe, AZN3980AUS Department Of Homeland Security · Washington, DC
Back to AD 2012-17-03