AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-02-R1')
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:2000-25-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-02-R1') 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.
N2977WRhinehart Christopher · Deerwood, MNN29788Lund Kevin J · Williamson, GAN2979BLearn 2 Fly LLC · Seminole, ALN2979CEnchanted Aircraft LLC · Santa Fe, NMN2979ERogers James R · Morriston, FLN2979PRussman Nicholas S · Farmersville, TXN297ACCavanaugh Flying Service Inc · Minden, NEN297JBCheney Livestock Corp · Casper, WYN2980DLimbach Ronald B · Verona, ILN2981MPavey Rocky A · Fairbanks, AKN2982EGauthier Peter J · Woodburn, ORN2984ZStitch Aero LLC · Sunnyvale, CAN2985EWelna John M · Saginaw, MNN2987GMuehlbauer Jeff J · Nenana, AKN2988EJones Mike G · Slaton, TXN298ACEagle Prairie Flyers LLC · Eau Claire, WIFirst renewal noticeN298JBank Of Utah Trustee · Salt Lake City, UTN298MASouthern Air Service Inc · Carbondale, ILN29900Parsons Dennard C · Mount Dora, FLN2990DHall Tyson · Leadville, CON2991DWatkins William C · Guy, ARN2991EPlayter Bud W · Greenville, MIN2992ESallade William L · Coudersport, PAN2992GYonge Charles Richard · Ocala, FLN2993GKilgore Samuel E Jr · Southaven, MSN2995GVincent Frederick D · Searsport, MEN2996GAngle Matthew G · Teton Village, WYN2996ZKerr Ian A · Redwood City, CAN2998EWenk Jennifer M · Beaufort, NCN2998GMiner Jay G · Seattle, WAN2999ZGodensun Aero LLC · Sutherlin, ORN299BCClark John Thomas Jr · North Salt Lake, UTN299LCFlight Contract Services Inc · Las Vegas, NVN299SAEnterprise General Aviation Network Inc · Dell Rapids, SDFirst renewal noticeN299SLSatermo Lee J · New Town, NDN29BHShearer Glendon E · Wall, SDN29CBHouston Robert · Murray, KYN29FFBriggs Aviation LLC · Virginia Beach, VAN29GLHometime Rv LLC · San Antonio, TXN29KRNeill Derek R · Shawnee, OKN29SGMusser Richard J · Lithia, FLN2AGCentral Air Parts Inc · Staunton, ILN2BNJensen Paul E · Exeter, NEN2EZScott Flying Service Inc · Bono, ARN2JGWetsu Enterprises Inc · Colorado Springs, CON2KTCambridge Valley Flying Club Inc · Shusann, NYN2PMDixon Morris M · Poynette, WIN2SGKcsi Aerial Patrol · Bakersfield, CAN2VTRegistration Pending · Fort Pierce, FLRegistration pendingN2ZZDel Carlo Gary · Tracy, CA
Back to AD 2000-25-02 R1