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.
N591CPCivil Air Patrol · Maxwell Afb, ALN5929TFlight School Of Gwinnett Inc · Lawrenceville, GAN592CPCivil Air Patrol · Maxwell Afb, ALN592JSStraut James M · Upper Saddle River, NJN593CPCivil Air Patrol · Montgomery, ALN594CMCameron John B · Iredell, TXN594CPCivil Air Patrol · Maxwell Afb, ALN594QHager Cecilia J · Fredericksburg, TXN594SMGpi Geospatial Inc · Orlando, FLN595DBStar Magic (Www) Inc · New York, NYN595MSClover Park Technical College · Lakewood, WAN595PZSomid Resources LLC · Choudrant, LAN595SPSchool Of Missionary Aviation Technology · Ionia, MIN5961JAtp Aircraft 2 LLC · Wilmington, DEN596CSVan Anda Aviation LLC · Apopka, FLN596FAOcala Aviation Services Inc · Ocala, FLN597DAb Prop Plane II LLC · Metairie, LAN597SPViolet Sparkle Pearl LLC · Hanover, NHN597TXCareer Track 2 LLC · Wilmington, DEN598MCTeichroeb Peter · Seminole, TXN598SPFb Aviation LLC · Minot, MEN599TSNbr Aviation · Bristow, VAN59EFTancredi Andrew D · Germantown, TNN59FFPeregrine Howard Partners II Lp · New Orleans, LAN59LJL & J Aviation Inc · Atwater, CAN59TWAb Prop Plane II LLC · Metairie, LAN6000VTextron Aviation Inc · Wichita, KSN60030Jmj Properties LLC · Atchison, KSN6004LJackson Mac Roy Jr · Hood River, ORN6004YYyky LLC · Walnut Creek, CAN60051Compass Rose Aviation LLC · Derby, KSN60053Textron Aviation Inc · Wichita, KSN6005JTextron Aviation Inc · Wichita, KSN6005SCompass Rose Aviation LLC · Derby, KSN60062Textron Aviation Inc · Wichita, KSN6006XTextron Aviation Inc · Wichita, KSN6007ATextron Aviation Inc · Wichita, KSN6009MKd 172 Ventures I LLC · Bellevue, WAN6009POh Air LLC · Mentor, OHN6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeN600PKGetzel Air LLC · Conover, WIN6012U6012u LLC · Union Gap, WAN6012ZChristiansen Aviation LLC · Wilmington, DEN6013JAerodrome LLC · Louisville, KYN6013KLdm LLC · Cuba, MON6013SStomio LLC · Covina, CAN6013VFlynn James H Jr · Saratoga Springs, NYN60143H2 Link Company · Lewes, DEN6014GBennett Michelle D · Middletown, NJN6014JDue West Aviation LLC · Gypsum, CO
Back to AD 2003-24-13