AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N421TFIntrepid Enterprises LLC · Wichita, KSN421TGRegistered aircraftN421TPDouble R Aviation LLC · Reno, NVN421TTEnvision Ventures LLC · Williston, NDN421TVYuba City Solar Millennium Fund LLC · Rocklin, CAN421TXHolly Factory · Alachua, FLN421UTR&C Welding And Fabrication Inc · Gering, NEN421VHead Rest Ltd LLC · Las Vegas, NVN421VAMagafly LLC · Bay City, MIN421VFN421vf LLC · Lindsay, TXN421VGCooper421 LLC · Haltom City, TXN421VJH C LLC · Ponca City, OKN421VR421vr LLC · Denver, CON421WBBas Part Sales LLC · Greeley, CON421WCOne Eyed Pilot LLC · Columbia, SCN421WEInternational Air Services Inc Trustee · Carson City, NVN421WKKb Air LLC · Bakersfield, CAFirst renewal noticeN421WNContractors Flight Service LLC · La Jolla, CAN421WPMach 1 LLC · Rogers, ARN421WSGandy John B · Conroe, TXN421WTWest One Holdings Inc · Cheyenne, WYN421XLLocaero Services Inc Trustee · Wilmington, DEN421XTAdam & Anya Holdings LLC · Wichita, KSN421XXLong William David · San Antonio, TXN421YBBotsis Aircraft Limited Inc · Chesterland, OHN421YWTrl Aviation LLC · Little Rock, ARN421YYVsa Leasing LLC · Linden, MIN421ZM3tr Aviation LLC · Longview, TXN421ZXBurmingham Don Trustee · Duarte, CAN421ZZ421zz LLC · Wilmington, DEN422CMAerostar Aviation LLC · Tucson, AZN422DBurton Rick · Vancouver, WAN422GMMidocin LLC · Southfield, MIN422PJCra Aviation LLC · Dickerson, MDN423TMJp Aviation Leasing LLC · Salt Lake City, UTN424JAJzj Air LLC · Wilmer, ALN426LJVenture Air Solutions Inc · Opa Locka, FLN4272CKamps Air LLC · Grand Rapids, MIN427CCBoard Of Trustees Of Southern Illinois University · Carbondale, ILN427JMPittman James L · Destin, FLN429GMResendiz Marcelino · Alamo, TXN429RCN429rc LLC · Gladwyne, PAN42AAN42aa LLC · Nantucket, MAN42HMSky West Aviation Inc Trustee · Albuquerque, NMN42MGSouth Aero Inc · Albuquerque, NMN42MLRegistered aircraftN42MWWalker Winston W Trustee · Tucson, AZN4308ZMike Victor Yankee LLC · Andover, MAN438EL1 Stop Sod & Landscaping Inc · Orlando, FLN43BMDodson International Parts Inc · Rantoul, KS
Back to AD 95-09-13