AD 2002-22-14
Registered aircraft · 137
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-22-14')
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-22-14')
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-22-14') 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-22-14') 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.
N223HTHillsboro Aviation Inc · Hillsboro, ORN225PRWindsock Management LLC · Little Rock, ARN229HTVertical Corp · Kalispell, MTN232PJHelibro LLC · Red Bluff, CAN234PHBank Of Utah Trustee · Salt Lake City, UTN249HVertol Systems Co Inc · Destin, FLN254SMBank Of Utah Trustee · Salt Lake City, UTN2773HSummit Helicopters Inc · Salem, VAN281JLBank Of Utah Trustee · Salt Lake City, UTN281SDCity Of San Diego · San Diego, CAN288DLTvpx Ars Inc Trustee · North Salt Lake, UTN28HXHelicopter Express LLC · Chamblee, GAN303VSVertol Systems Company Inc · Destin, FLN304HALyons Aircraft Leasing LLC · Hillsboro, ORN307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CAN310MPSuperior Aviation Solutions LLC · Mooresville, NCN316LHLohman Helicopter LLC · Lewiston, IDN32240Ventura County Sheriffs Department · Camarillo, CAN334MPPope James Dean · Lewiston, IDN336MPPope James Dean · Lewiston, IDN338MPPope James Dean · Lewiston, IDN33HXCopter Lease LLC Trustee · Albuquerque, NMN359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN369ECEcolift Corp · San Juan, PRN373PACopter Lease LLC Trustee · Albuquerque, NMN374PACopter Lease LLC Trustee · Albuquerque, NMN376PAPathfinder Leasing LLC · Anchorage, AKN378PACopter Lease LLC Trustee · Albuquerque, NMN37HXHelicopter Express LLC · Chamblee, GAN3803CState Of Colorado Department Of Public Safety · Lakewood, CON3804CState Of Colorado Department Of Public Safety · Lakewood, CON380PLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404HAHillsboro Aviation Inc · Hillsboro, ORN41VSVertol Systems Co Inc · Destin, FLN41WLCopter Lease LLC Trustee · Albuquerque, NMN4218SAgriforrestal Applications Inc · Arcadia, FLN4359FPetroleum Helicopter Technology Inc · San Antonio, TXN449RCCounty Of San Diego · El Cajon, CAN456TARoberts Aircraft LLC · Cheyenne, WYN49732Bank Of Utah Trustee · Salt Lake City, UTN500EHHilcorp Equipment LLC · Anchorage, AKN502THTemsco Helicopters Inc · Ketchikan, AKN508EHHilcorp Equipment LLC · Anchorage, AKN512PAPatriot Aviation Inc · Greenville, DEN515Savauge Air LLC · North Las Vegas, NVN530NCCopter Lease LLC Trustee · Albuquerque, NMN534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN534NCCopter Lease LLC Trustee · Albuquerque, NMN549RLAircraft Trustee Services Inc Trustee · Dover, DEN551HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2002-22-14