AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N2993YBranch Robert W · Fort Mohave, AZN2994ADicicco Matthew Trustee · Los Gatos, CAN2994ESkyventure Aviation LLC · Battle Creek, MIN2994R2994r Aircraft Leasing LLC · Spanish Fork, UTN2994TZakraisek Donald S · Sandy, UTN2994XBas Part Sales LLC · Greeley, CON2994ZAir Ads Inc · El Cajon, CAN29950Nichols William K · Bainbridge, GAN2995CAmerican Airpower Heritage Flying Museum · Dallas, TXN2995FCj3 Aviation LLC · Idaho Falls, IDN2995GVincent Frederick D · Searsport, MEN2995LS&S Wings And Wheels LLC · Wilmington, DEN2995RAbj Aviation LLC · Montgomery, OHN2996CSutton Aircraft Salvage LLC · Palmer, AKN2996FSmooth Air LLC · Mequon, WIN2996PHenry Kent B · Prescott, AZN2996TSims Barry Don Sr · Canadian, TXN2996XEagle Sky Patrol Inc · Deadwood, SDN2996YCrowe Timothy P · Gilbert, AZN29970Andrecheck Cynthia R · Bethel, AKN29972Windblown Ranch Inc · Echo, ORN2997CSmith Philip W · Copeland, KSN2997GHiemenz Thomas S · Greenwood, INN2997LStorke Paul E · Laguna Beach, CAN2997YSkyriders LLC · Flagstaff, AZN2997ZHoppner Gina · Fairbanks, AKFirst renewal noticeN2998FChristian Halls International · Arlington, TXN2998KWallingsford Don C · Yorba Linda, CAN2998LJentes Charles A · Smithville, OHN2998MM T Aviation LLC · Grove, OKN2998PRosendahl Peter · Anchorage, AKN2998TMartony Joseph M · Chandler, AZN2998YReynolds Peter · Athol, MAN2999AFindly Raymond Lee · Ravenna, KYN2999CCarnine Daniel L · Seeley Lake, MTN2999LSodt Brian K · Kernersville, NCN2999MLopez Eve · Santa Monica, CAN2999NGarcia Michael R · Marshall, VAN2999RMatthews Flying Club LLC · Ogden, UTN2999TAnderson Richard C · Dickson, TNN2999XPoore Zack W · Mcdonald, KSN2999ZGodensun Aero LLC · Sutherlin, ORN299AGSky West Aviation Inc Trustee · Albuquerque, NMN299ARAutry Timothy R · Stedman, NCN299BBCornell David A · Wasilla, AKN299BFMacvey Troy R · Milan, INN299BGHarrison Rv Inc · Jefferson, IAN299BWKornelson Roseann S · EmoNon-citizen corporation, flight hours not reportedN299CAScenic Concepts LLC · La Crosse, WIN299DASybesma Justin T Md · Benton Harbor, MI
Back to AD 2007-04-19 R1