AD 75-22-02
Registered aircraft · 133
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:75-22-02')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-22-02')
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:75-22-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-22-02') 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.
N30111Sky Walker Aviation LLC · Indianapolis, INN304HALyons Aircraft Leasing LLC · Hillsboro, ORN3053QWest Valley Aviation Inc · Five Points, CAN313BNorthwest Helicopters Inc · Olympia, WAN333XLCj Air LLC · Nezperce, IDN334WNPope Jim D DBA · Lewiston, IDN33HXCopter Lease LLC Trustee · Albuquerque, NMN353RCN353rc LLC · Chelan, WAN3605Mann Peter D · Willows, CAN374PACopter Lease LLC Trustee · Albuquerque, NMN3803CState Of Colorado Department Of Public Safety · Lakewood, CON3804CState Of Colorado Department Of Public Safety · Lakewood, CON3XLNixon Helicopters LLC · Mentone, CAN4040PR & R Conner Aviation LLC · Conner, MTN4069ROlympic Jet Inc · Olympia, WAN406JPHeli-Works Flight Services LLC · Deer Lodge, MTN40722West Valley Aviation Inc · Five Points, CAN41109Lrh Equipment LLC · Pendleton, ORN4376DPlanes Of Fame Air Museum · Chino, CAN43FKKaman Aerospace Corp · Bloomfield, CTN444SJJones Flying Service · Biggs, CAN449RCCounty Of San Diego · El Cajon, CAN453CCHelo 1 LLC · Anchorage, AKN474THTop Hand Inc · Laurel, MTN5073XMartins Dusters Inc · Colusa, CAN515Savauge Air LLC · North Las Vegas, NVN51AFEastern Stearman Inc Trustee · Leesburg, VAN526MWMountain West Helicopters LLC · Saratoga Springs, UTN534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN534NCCopter Lease LLC Trustee · Albuquerque, NMN540FUAdf Helicopters Inc · Brewster, WAN549RLAircraft Trustee Services Inc Trustee · Dover, DEN574PDRegistration Pending · Arbuckle, CARegistration pendingN58468Long-Line Leasing LLC · Saratoga Springs, UTN599HFNext Level Marine LLC · Mount Pleasant, TXN59HPHansen Albert C · Mojave, CAN606HFAgriforrestal Applications Inc · Cape Coral, FLN61650Great Falls Property LLC · Auburn, MEN6180AJones Aviation Inc · Biggs, CAN6257PPremier Aircraft Services LLC · Bakersfield, CAN6261CVi1 LLC · Brewster, WAN62767Aquila Helicopters LLC · Elliston, MTN638HAHelicopter Applicators Inc · Gettysburg, PAN64770Premier Aircraft Services LLC · Bakersfield, CAN648HAHelicopter Applicators Inc · Gettysburg, PAN661UHRegistration Pending · Midlothian, TXRegistration pendingN669HV2plus 1 LLC · Homer, AKN66HJEcho Foxtrot Holdings LLC · Lewes, DEN674THTimberline Helicopters Inc · Sandpoint, IDN67FURotak LLC · Anchorage, AK
Back to AD 75-22-02