AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.
N21718Blomgren David · Phoenix, AZN2171XGlobal Flight Training Solutions Inc · Immokalee, FLN21722Western Properties Investors And Advisors LLC · Laguna Niguel, CAN2172JTaylor A Pharr Esq LLC · Alexander City, ALN2172WGo Around LLC · Elburn, ILN21733Bradley Ralph W Jr · Newbury Park, CAN2173ERiva LLC · Sioux Falls, SDN2173ZTegridy Equipment Leasing LLC · Aurora, ORN21744Oatdog Aviation LLC · Atlanta, GAN21746Sky West Aviation Inc Trustee · Albuquerque, NMN2174911:11 Enterprises LLC · San German, PRN2174VRjr Leasing LLC · Wilmington, DEN2175QTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2175WIndustry Machine Design & Automation Inc · Camarillo, CAN2176STango-Alpha LLC · Saint Charles, MON21778Nodak Aircraft Leasing LLC · Fargo, NDN2177QKovarik Lucas M · Ord, NEN21787Birch Jerome I Trustee · Anchorage, AKN21796Seegmiller Geoffrey · Houston, TXN2179MKairez Carolyn E · Punta Gorda, FLN217DLValiair Lc Trustee · Casper, WYN217EPEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeN2181AL&C Ventures LLC · Clovis, NMN2181NState Of Oregon · Salem, ORN2182FKleen Sheen IV LLC · Bowling Green, KYN2182KDura Built LLC · Greensburg, KYN2183JMichael Nehring Inc · Mohall, NDN2183PBarney Northcote Inc · Riverside, CAN2186ZNational Products Inc · Seattle, WAN218DEFrysinger Investments LLC · Hudson Oaks, TXN218SGMg Air Ventures LLC · Tucson, AZN2192PSandoval Tax Cpas Inc · Bakersfield, CAN2193WAzalea Utilities Inc · Summerville, SCN2194LState Of Wisconsin · Madison, WIN21964Matt Anchordoguy Co LLC · Vina, CAN2196LAerolisse LLC · Chouteau, OKN21971Mp Aviation LLC · Buffalo, NYN219CACivil Air Patrol · Maxwell Afb, ALN219CEGillison William · Lake Village, ARN219CSFlorida Department Of Law Enforcement · Tallahassee, FLN219MCHansen Todd · Friday Harbor, WAN219PDWolfair LLC · Lewes, DEN219SB155 Aviation LLC · Redwood City, CAN219SPLouisville Aircraft Leasing LLC · Louisville, KYN21LFLunken Flight Training Center LLC · Cincinnati, OHN21SZVista Air Inc · Pacoima, CAN2200FQualitair LLC Trustee · MichelstadtN2202NAlcyone Trust Corp Trustee · Wichita, KSN2202QLewis University · Romeoville, ILN22044182 Flight Corp · Bronx, NY
Back to AD 2003-24-13