AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N211PAPiedmont Air Services LLC · Helena, MTN211PTCappe Investment Group LLC · Homestead, FLN211SSherrifs Office Kane County Utah · Kanab, UTN211SQRare Air Inc · Waterford, MEN211SVMatthews Aviation LLC · Greensboro, NCN211SWOrion Aviation LLC · Jeffersonville, INN211TSalazar Frank A · Los Angeles, CAN211TCMayer William P · Anchorage, AKN211TKJaye Jeffrey S · Vacaville, CAN211WTBetelgeuse Aviation LLC · Houston, TXN21201Delta Aviation Inc · Monticello, MNN21202Diamond David Samuel Trustee · Truckee, CAN21203Provence Michael D · Fort Worth, TXN21205Hodl Partners LLC · Allen, TXN21206Baird David W · Kanab, UTN21207Jerdee Jonathan E · Moorhead, MNN2120FWare Brandie W · Nikiski, AKN2120GSouthern Arizona Balloons Inc · Tucson, AZN2120ROda Mark E · Angola, INN2120YSchwier Joyce M · Benton City, WAN2120ZHenry John M · Anchorage, AKN21215Van Steenkist Grant · Spokane Valley, WAN21218Street Raymond E Jr Trustee · Palmer, AKN21219Dubose Brian · West YorkshireN2121GSutton Aircraft Salvage LLC · Palmer, AKN2121LDl Contractors Inc · Rexburg, IDN2121QSchardt James A · Garden Valley, CAN2121RDengler Phillip L · Bordentown, NJN2121YMclanahan John P · Culpeper, VAN2121ZRegistered aircraftN21224Registration Pending · Brenham, TXRegistration pendingN21227Fly21227 LLC · Charleston, WVN2122UAnderson Aerial Spraying Service Inc · Canby, MNN21230Beggs Construction Inc · Salem, ORN21234Positive Rate LLC · Kenosha, WIN21236Gjedde David C · Morristown, TNN21237Parker Jeff · Chelsea, ALN21238Hatfield Derik L · Mesa, AZN2123GCasten Scot R · Vernonia, ORN2123NKangas Brian Alfred · Houghton, MIN2123QMellor James F · Spanish Fork, UTN2123RHowell William J · Incline Village, NVN2123ZGauntt Chep R · Pasco, WAN21244Connors Geoffrey M · La Center, WAN21246Eastern Stearman Inc Trustee · Leesburg, VAN21247Registered aircraftN21249Western Kentucky Petroleum Inc · Osage Beach, MON2124GSilicz Alexander Nicholas · Shafter, CAN2124QBas Part Sales LLC · Greeley, CON2124RKokjer Kenneth J · Fairbanks, AK
Back to AD 97-01-13