AD 2022-08-13
Registered aircraft · 3,069
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:2022-08-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-08-13')
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:2022-08-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-08-13') 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.
N137BABemidji Aviation Services Inc · Bemidji, MNN138JMFull Throttle Aviation LLC · Clayton, DEN139MCBilly Bobs Flying Service LLC · Bay, ARN139SCNew Ulm C90 LLC · Marshall, MNN13GXEpic II LLC · Reno, NVN13GZGuardian Flight LLC · South Jordan, UTN13SUDownwind LLC DBA · Salt Lake City, UTN141DZLiam 750 Inc · Charlevoix, MIN141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVN141RFRandigo LLC · Wilmington, DEN1421ZMng Leasing LLC · Bottineau, NDN142DVSalerno Robert J · Cornwall, NYN142EEHound Dog Aircraft LLC · Lawrence, KSN143AUSkydive Guam Inc · Barrigada, GUN143ZUsda Forest Service Fire & Aviation · Boise, IDN144CMeyers Construction Inc · Fresno, CAN144JTFlight 1976 LLC · Kennesaw, GAN144KSAas LLC · Ovid, MIN1455TKenmore Air Harbor LLC · Kenmore, WAN145GPTextron Aviation Inc · Wichita, KSN145KAKamaka Air LLC · Honolulu, HIN145SLCash Depot Ltd · Green Bay, WIN145WAMartinaire Aviation LLC · Addison, TXN146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN146SLDodson International Parts Inc · Rantoul, KSN146WMWatermakers Air Inc · Fort Lauderdale, FLN148SAZuni LLC · Kirkland, WAN148SHBank Of Utah Trustee · Salt Lake City, UTN149CCCianbro Corp · Baltimore, MDN149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN149SFAlpine Aviation Inc · Provo, UTN149SHBank Of Utah Trustee · Salt Lake City, UTN14GVScott T LLC · Portland, ORN14RPAs350 LLC · Missoula, MTN1500EVaughans Aircraft Leasing LLC · Claremore, OKN1502BAeroag LLC · Portland, INN1502UCentral Ag Air LLC · Marion, KSN15054Air-Ag Inc · Tarboro, NCN15074Wells Flying Services LLC · Holdrege, NEN1507KDakota Air Spray LLC · Huron, SDN150ACJohnson Airspray Inc · Argyle, MNN150GWRocinante Air LLC · Cincinnati, OHN150KReilly John P · Friendsville, PAN15102Moes Crop Dusting Service Inc · Marysville, CAN1515GKidd Clifford L · Monahans, TXN15189Tri Rotor Spray & Chemical · Ulysses, KSN1518ZMoss Jimmy David DBA · Tillar, ARN1519ZFlatland Aviation LLC · Indianola, MSN151BCBrc Az Aviation LLC · Scottsdale, AZN151CAAcc Integrated Services Inc · Milwaukee, WI
Back to AD 2022-08-13