AD 2017-22-14
Registered aircraft · 3,758
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:2017-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:2017-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:2017-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:2017-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.
N1107MAsifd LLC · Dallas, TXN110CPPruitt Corp · Leesburg, VAN110DUBank Of Utah Trustee · Salt Lake City, UTN110MWRegistered aircraftN110QSRegistered aircraftN111BPAlabama Farmers Cooperative Inc · Decatur, ALN111CCWilmington Trust Co Trustee · Wilmington, DEN111CMMunday Aviation LLC · Highland, UTN111EDBnp Holdings LLC · Lakewood Ranch, FLN111ELContinuum Aviation LLC · Oklahoma City, OKN111FKFk Air LLC · Miami, FLN111KKKohler Co · Kohler, WIN111NGBank Of Utah Trustee · Salt Lake City, UTN111QSRegistered aircraftN111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJN112DUBank Of Utah Trustee · Salt Lake City, UTN112MYAir Force Fun LLC · Woodbury, NYN112QSRegistered aircraftN113DQBank Of Utah Trustee · Salt Lake City, UTN113QSRegistered aircraftN113SRAdams Aviation Services Inc Trustee · Wilmington, DEN114DUBank Of Utah Trustee · Salt Lake City, UTN114QSRegistered aircraftN1150MBakko Aviation LLC · Glenwood, MNN115ADAmerican Promotional Events Inc · Florence, ALN115BATextron Aviation Inc · Wichita, KSN115DUBank Of Utah Trustee · Salt Lake City, UTN115JSRegistered aircraftN115LFAirlynner LLC · Jackson, WYN115MHA7p Trust Co Inc Trustee · Cheyenne, WYN115QSRegistered aircraftN115SEAdvanta Aviation 3500 LLC · La Jolla, CAN115TRTasco LLC · New York, NYN116BTUmb Bank Na Trustee · Salt Lake City, UTN116DUDelta Air Lines Inc · Atlanta, GAN116HFAirbourne International Inc · Wilmington, DEN116HLWorld Tech Aviation LLC · Valencia, CAN116NCNdc Equipment Leasing LLC · Lake Forest, ILN116QSRegistered aircraftN116SFAlten Consulting LLC · Fort Lauderdale, FLN116TACbp Air Logistics LLC · Statham, GAN117AACorsair Two LLC · Hillsboro, ORN117DUBank Of Utah Trustee · Salt Lake City, UTN117MSStar Flight LLC · Greenwich, CTN117NTSanford Health · Sioux Falls, SDN117QSRegistered aircraftN117SFWildstar Partners LLC · Pittsford, NYN117TPR&C Xrs Owner LLC · Beverly, MAN118DBCitation X Parts LLC · Liberty, NCN118DUBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2017-22-14