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.
N74BGReliance Aviation LLC · Mendon, NYN74CPCivil Air Patrol · Maxwell Afb, ALN74DWBas Part Sales LLC · Greeley, CON74FFFf22 LLC · Scottsdale, AZN74GKFerrell Mobile Homes Inc · Benton, MON74PYPapa Yankee LLC · Cameron, MTN74SHStreebin David A · Elkhorn, NEN750CPCivil Air Patrol · Maxwell Afb, ALN751CPCivil Air Patrol · Maxwell Afb, ALN751ESHat Trick Aviation LLC · Dover, DEN751MLQueensland Air LLC · Chicago, ILFirst renewal noticeN751SPHagele Aviation LLC · Hillsboro, ORN752DWFlying Start Aero Services LLC · Reno, NVN752EREmbry-Riddle Aeronautical University Inc · Prescott, AZN752ESGoodrich Jesse R · Vernal, UTN752LSouthwest Aviation Enterprises · Haslet, TXN753CPCivil Air Patrol · Maxwell Afb, ALN753DBFritz Daniel Trustee · Lodi, CAN753GWAtp Aircraft 4 LLC · Wilmington, DEN753LAJoy Air LLC · Scottsdale, AZN753SCJuliet Charlie Aviation LLC · Keizer, ORN753WSSulimoff Wesley Thomas · Lake Havasu City, AZN754CPCivil Air Patrol · Maxwell Afb, ALN754FGRidgeline Assets LLC · Wilmington, DEN754MEKaetzel Anthony · Portland, ORN754SPNavy Annapolis Flight Center Inc · Edgewater, MDN755BNicholson Enterprises LLC · Oconomowoc, WIN755SPNavy Annapolis Flight Center Inc · Edgewater, MDN755WMBravo Aircraft LLC · Alpharetta, GAN756DDAirade LLC · Davis, CAN756FRobertson Lisa O · Jackson, WYN756MPwc Aviation LLC · Omaha, NEN756SPCrest Airpark · Kent, WAN75727Silverhawk Aviation Academy Oregon LLC · Ontario, ORN757RBTaa Aviation LLC · Lewes, DEN7582BWandering Chicken LLC · Kalispell, MTN758CPCivil Air Patrol · Maxwell Afb, ALN758JPR & P Investments Inc · Visalia, CAN758STDel LLC · North Miami, FLN759CACivil Air Patrol · Maxwell Afb, ALN759KLPcw Aviation LLC · Fort Worth, TXN759THJones Darrell · Columbia, MON75AKC U Later Aviation LLC · Holliday, TXN75BNBernic Inc Trustee · Wilmington, DEN75CPValiair Limited Company · Casper, WYN75FFFf22 LLC · Scottsdale, AZN75GRGreat Frigatebird LLC · Jupiter, FLN75KBJoseph Carter Realty Inc · Jasper, ALN75PDHaher Thomas R · Tully, NYN75RBBarr Air Patrol LLC · Mesquite, TX
Back to AD 2003-24-13