AD 2002-15-08
Registered aircraft · 1,064
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:2002-15-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-15-08')
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:2002-15-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-15-08') 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.
N358PAPathfinder Leasing LLC · Anchorage, AKN358SHSycan Corp DBA · Paso Robles, CAN358TVTiny Bubbles Aviation Inc · Pacoima, CAN3598DPope James Dean · Lewiston, IDN359EVAlaska Remote Outfitters LLC · Kenai, AKN359FBPhoenix Police Department · Phoenix, AZN359PANs Air Leasing LLC · Wilmington, DEN359SHPaso Air Leasing LLC · Paso Robles, CAN35HXHelicopter Express LLC · Chamblee, GAN35JPEleven 11 Ventures LLC · Helena, MTN35YYMike Rinker Aircraft LLC · Union City, TNN3604TRotorcraft Support Inc · Fillmore, CAN360CHCoastal Helicopters Inc · Juneau, AKN361TXTexas Department Of Public Safety · Austin, TXN362ACBank Of Utah Trustee · Salt Lake City, UTN364TARoberts Aircraft LLC · Cheyenne, WYN365JABank Of Utah Trustee · Salt Lake City, UTN365MYIntegrity Aircraft Title Holdings LLC · Portland, ORN365NCBank Of Utah Trustee · Salt Lake City, UTN365RTIntegrity Aircraft Title Holdings LLC · Portland, ORFirst renewal noticeN365UQAnalar Corp · Princeton, NJN367AMAir Services International Leasing LLC · Fort Lauderdale, FLN368EVValiair Limited Company Trustee · Casper, WYN369WMTeam C & H Inc · Jacksonville, FLN36TVUS Helicopters Inc · Marshville, NCN370HPOklahoma Department Of Public Safety · Norman, OKN370NCState Of North Carolina · Raleigh, NCN370SRDepartment Of Homeland Security · Washington, DCN372HSBrown Helicopter Inc · Pensacola, FLN373HSHuff Air LLC · Uvalde, TXN375MBMh22 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, AKN383EDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN384AKAlpha 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, GAN38MDBank Of Utah Trustee · Salt Lake City, UTN390NSNorthstar Trekking LLC · Juneau, AK
Back to AD 2002-15-08