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.
N20204Bellingham James G · Baltimore, MDN20207Disheroon Donald · Houston, TXN20208American Patrols Inc · Midland, TXN2020GLyon John · Santa Barbara, CAN2020QKaravan LLC · Gilford, NHN2020XCullman Aviation Inc · Cullman, ALN2020ZAbrahamson Nicholas P II · Grosse Ile, MIN20211Lee Cas LLC · Macomb, ILN20213Valiair Limited Company Trustee · Casper, WYN20214Bingairman LLC · Newville, PAN20215Northeastern Financial LLC · New Gloucester, MEN20216Manke Derek E · Canton, GAN20217La Valle Jacque D · Lexington Park, MDN20218Emporia Flying Club Inc · Emporia, KSN20219Koenitzer Judson B · Chetek, WIN2021QHamilton Gregory J · Avon Lake, OHN2021ZMclean Jr Rufus C · Rockingham, NCN20221Ohair Mark O · Lampasas, TXFirst renewal noticeN20222Coe Douglas R · Roswell, GAN20223Roberts Stephen Wade · Friendswood, TXN20225N20225 LLC · Pottsboro, TXN20226Morris Aero Club · Towaco, NJN20229Sale Reported · Wilmington, DESale reportedN20230Cessna 20230 LLC · Windsor, CAN20232Lopez Tail Draggers LLC · Lopez Island, WAN20233Jenkins Robert W · Fredericktown, OHN20236Safety In Motion Flight Center Inc · Puyallup, WAN20237Shortway Pilots Inc · Clearfield, PAN20238Valenti Jeffery N · Eastport, NYN2023XZim Sim LLC · Charleston, SCN2023YCassero Ronald V · Santa Rosa, CAN20241Aviation 241 Inc · North Lima, OHN20242Gent John F · Wellman, IAN20243Webb John W · Elkins, WVN20246Olek Brad · New Richmond, WIN20247Grace Ellen M · Bloomville, NYN2024SRegistration Pending · Sublette, KSRegistration pendingN2024XMahaney Nicholas · Tahlequah, OKN20250Kooistra Samuel R · Honobia, OKN20251Granahan Eric J · Burlington, WIN20252Morino William D · Palos Verdes Est, CAN20259Mackin Robert Michael · Castro Valley, CAN2025QNelson Gerald E · Burlington, WAN2025YMarine Resources Inc · Gilbert, AZN2025ZVgh Holdings LLC · Wilmington, DEN20262Sherman Aviation Inc · Redmond, ORN20264Moltz Larry D · Seguin, TXN20267Knot Grounded Aviation LLC · Napanoch, NYN20268Fox Two LLC · Camino, CAN2026XGonzales Alvin S · Mount Prospect, IL
Back to AD 97-01-13