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.
N21251De La Fuente Rene M Trustee · Yorktown, VAN21254High Wing 182 LLC · Lenoir City, TNN21257Stc Aviation Services LLC · Logan, UTN2125QRizzuto Nunzio Stephen · Decatur, ALN2125RHogue William B Jr · Simi Valley, CAN2125XMathews Wade · Wichita Falls, TXN2125YPalmer Ronald Everett Trustee · Sonoma, CAN2125ZStone Michael D · Boise, IDN21260Airborne Athletics Inc · Bloomington, MNN21268Aufderhar Kenneth G · Lopez Island, WAN2126GSmith Jonathan R · Waxhaw, NCN2126QDurable Industrial Finishing Co Inc · Tucker, GAN21271Barnett Ryan M · El Reno, OKN21272Eagle Aviation Inc · Tucson, AZN21274Quax LLC · Wallkill, NYN2127FBrice Adam R · Camas, WAFirst renewal noticeN21281Horne Randall W · Millington, TNN21289High Flight Academy LLC · Allison Park, PAN2128EFly For Fun LLC · Rockville, MDN2128GBeckhoff Michael A · Casper, WYN2128RCreasey Daniel L · Arnold, MON21291Castleair LLC · Dothan, ALN21295Tauscher Robert C · Friday Harbor, WAN21297Bradley Robert S M Sr · Rougemont, NCN21299L-Bird LLC · Hood River, ORN2129DLoadholtz Heath T · Watford City, NDN2129FStewart Madison F Co Persona Representative · Broken Arrow, OKN2129QEarnshaw Larry L · Erie, CON2129YEdwards Air LLC · Raleigh, NCN212AFDoolittle Aero LLC · Goodyear, AZN212ANCalifornia In Nice Inc · San Jose, CAN212BCRoberts Randall K · Clayton, NMN212BGRegistered aircraftN212CCChristenson Charles F · Auburn, WAN212CPTj Air Holdings Inc Trustee · Wilmington, DEN212DARegistration Pending · Phoenix, AZRegistration pendingN212GBSooner Farms LLC · Siloam Springs, ARN212HRExport Aviation LLC · Santa Fe, NMN212KTLanier Howard W · Willis, TXN212MBEuro 2000 Inc · Merritt Island, FLN212PMEllisor Don · Grapeland, TXN212RVMinuteman 12 LLC · Wilmington, DEN212SBSycamore Partners LLC · Johnson, ARN212SWRarden Matthew W · Albuquerque, NMN212TMSchuldt Scott A · North Little Rock, ARN212WKRbm Adventures LLC · Jamestown, NYN212WLPeace Jiles V · Easley, SCN21302Blackburn James E · Upland, CAN21310Bagnell Enterprises LLC · Anaconda, MTN21315Clinical Anatomy Associates Inc · Mason, OH
Back to AD 97-01-13