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.
N19643Kuester Ryan J · West Point, NEN19644Hyde Shawn M · Columbus, OHN19646All2fly LLC · Atlanta, GAN19648Registration Pending · Cumming, GARegistration pendingN1964FLombardo Russell S · Fostoria, MIN1964QAction Air LLC · Missoula, MTN1964ZGreene John P · Yuba City, CAN19650Wingsleasing LLC · Wichita, KSN19655Kincaid William R · Niceville, FLN19657Thomas Mark E · Corpus Christi, TXN19658Gavel Robert E Jr · Keaau, HIN19665H&L Axelsson Inc · Cape May, NJN19667Rich Lucas Aircraft Sales LLC · Lincoln Park, NJN19668Yent Kevin N · Tampa, FLN19669Sprague John F · Chico, CAN1966FD & S Aviation LLC · Spring, TXN1966GAir Services International Charters LLC · Fort Lauderdale, FLFirst renewal noticeN19671Cascade Aviation LLC · Burlington, WAN19673Transair Inc · Blue Ridge, GAN19674Mcgraw Amiyah S · Jurupa Valley, CAN19676Whitman David L Jr · Centreville, VAN19679N19679 LLC · Opa Locka, FLN1967SFullerton Airport Pilot Association · Fullerton, CAN1967USmith Bernard A · Wasilla, AKN1967XInternational Air Services Inc Trustee · Carson City, NVN19680Proflight Services LLC · West Newton, PAN19681J & J Shop Heliair LLC · Laurel, DEN19682Steward James Mark · Colorado Springs, CON19684Belt Jay D · Bluefield, WVN19687Dg Aviation LLC · Mechanicville, NYN19688Vista Air Inc · Pacoima, CAN1968AChristopher Chester F · Bay Saint Louis, MSN1968FMedia Stew LLC · Carson City, NVN1968ZDuffel Christopher · Bellevue, WAN19692Babyshark LLC · Duncan, OKN19694Farrell Timothy S · New Meadows, IDN19695Saint Aviation Inc · Dunnellon, FLN19698Northern Air Aviation LLC · Naples, IDN1969EC M & T Aero Inc · Cedar Rapids, IAN1969KRegistered aircraftN1969QKalis Jeffrey J · Sparta, MIN1969XCrouch Jeffrey L · Rockingham, NCN1969ZDownen David J · Murrieta, CAN196ABrennemann Brian L · Hyannis, NEN196ARHeihn Daniel M · Soldotna, AKN196AVWarren Mark W · Arlington, WAN196CAHyannis Air Service Inc DBA · Hyannis, MAN196FSTechnical Education Services Inc · Virginia Beach, VAN196GCZuni LLC · Kirkland, WAN196TCClements Dylan A · Burlington, WI
Back to AD 97-01-13