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.
N780JAPhoenix East Aviation LLC · Daytona Beach, FLN7815DAviation Training LLC · Wilmington, DEN781BGVan Anda Aviation LLC · Apopka, FLN781DKSpruce Ave Air LLC · Phoenix, AZN781JAPhoenix East Aviation LLC · Daytona Beach, FLN781SAMeyers Terry E · Galesburg, NDN781SPJw Wings LLC · Midlothian, TXN782BGMt Aviation LLC · Fairbanks, AKN782CPCivil Air Patrol · Maxwell Afb, ALN782JAAanonsen Per · Flagler Beach, FLN782RMMbs Aviation LLC · York, SCN782WWDraco Flight School DBA · Chino, CAN783BGAir Shares LLC · Casper, WYN783CPCivil Air Patrol · Maxwell Afb, ALN783EAElevation Air Capital LLC · Janesville, WIN783EPEpic Aviation Inc · New Smyrna Beach, FLN783EREmbry-Riddle Aeronautical University Inc · Prescott, AZN783SFBremfour Aviation Group Inc · Wilmington, DEN783WWThomas Michael D · Centralia, WAN7848TChristiansen Aviation LLC · Wilmington, DEN784ACRochefort Michael A · Panama City, FLN784BGSuperior Flying Services LLC · Superior, WIN784DRMyren Jason A · Marion, IAN784ERTextron Aviation Inc · Wichita, KSN784JATextron Aviation Inc · Wichita, KSN784SAEastern Cincinnati Aviation Inc · Batavia, OHN784SPSaz Dynamics LLC · Daly City, CAN785BGVermont Flight Academy · South Burlington, VTN785ERTextron Aviation Inc · Wichita, KSN785LCDch Aviation LLC · Scottsdale, AZN785SASpringate Scott T · Chelan, WAN786CPWings Over Texas Holdings LLC · Denton, TXN786ERTextron Aviation Inc · Wichita, KSN786FAAb Prop Plane II LLC · Metairie, LAN786FGRidgeline Assets LLC · Wilmington, DEN786KASky West Aviation Inc Trustee · Albuquerque, NMN786SAGulf Aviation Holdings I LLC · Seattle, WAN786SPDevacana Transport Ltd · Lewes, DEN786TFAmerican Corporate Executive Services · Plantation, FLN786TMNorthwoods Camps LLC · North Kingstown, RIN786WRParagon Air Group · Fort Worth, TXN787FAAb Prop Plane II LLC · Metairie, LAN787GLTfa Holding Corp · Daytona Beach, FLN787LFH&R Aviation LLC · West Linn, ORN787MDGeorgia Forestry Commission · Macon, GAN787PMJacobs Philip · Dickson, TNN787SPSierra Tango Ventures LLC · Monte Sereno, CAN787WWDye Kent · Washington, PAN788CPCivil Air Patrol · Maxwell Afb, ALN788FAAb Prop Plane II LLC · Metairie, LA
Back to AD 2003-24-13