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.
N728SPFleetshares N728sp Inc · Leesburg, VAN728TAWbl Air II LLC · Minneapolis, MNN729CPCivil Air Patrol · Maxwell Afb, ALN729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILN729ELRegistered aircraftN729LUTextron Aviation Inc · Wichita, KSN729MTHochreiter Heinrich · Bellingham, WAN729SPMars Aerospace Inc · Bay Shore, NYN72CEChad A Mcgowan Pc · Rock Hill, SCN72EFN72ef LLC · Canton, GAN72FFFf22 LLC · Scottsdale, AZN72KFKirkpatrick John Drew · Post, TXN72MCAa-Aero Inc · Fairfield, NJN72MRSnide Thomas C · Dublin, OHN72RKAerial Services Inc · Cedar Falls, IAN72USUnited States Aviation Underwriters Inc · Toledo, OHN72ZGSale Reported · Hood River, ORSale reportedN730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZN730LUTextron Aviation Inc · Wichita, KSN730WMDennings Greg B · New Bremen, OHN731CLNby Productions · Manassas, VAFirst renewal noticeN731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN732CPCivil Air Patrol · Maxwell Afb, ALN732LUTextron Aviation Inc · Wichita, KSN732VFVictor Fox Aviation LLC · Newport Beach, CAN7339MBroadwell Group Inc · Acworth, GAN733CNChristiansen Aviation LLC · Wilmington, DEN733EREmbry-Riddle Aeronautical University Inc · Prescott, AZN733KMKhm LLC · Chardon, OHN733LUTextron Aviation Inc · Wichita, KSN733PRTextron Aviation Inc · Wichita, KSN733SHChristiansen Aviation LLC · Wilmington, DEN733TUChristiansen Aviation LLC · Wilmington, DEN734FGTextron Aviation Inc · Wichita, KSN734LUTextron Aviation Inc · Wichita, KSN735CPCivil Air Patrol · Maxwell Afb, ALN735KMDureiko Martin · Miami, FLN735RRMiga Holdings LLC · Flower Mound, TXN735SW5 Sierra Whiskey LLC · Sonora, CAN735WWRegistered aircraftN736SCGolf Aviation LLC · Oregon City, ORN7371Registered aircraftN737EBVx Ventures LLC · Castle Rock, CON738CPCivil Air Patrol · Maxwell Afb, ALN739CPCivil Air Patrol · Maxwell Afb, ALN739TWAviolease LLC · Vancouver, WAN739VJ739vj LLC · Brooklyn, NYN73CHAb Prop Plane II LLC · Metairie, LAN73ESWilmington Trust Co Trustee · Wilmington, DEN73MHRainier Flight Service LLC · Renton, WA
Back to AD 2003-24-13