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.
N813EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN813GFChristiansen Aviation LLC · Wilmington, DEN813HCGeorgia Forestry Commission · Macon, GAN813JHKqm Aviation · Bristow, VAN813KSFargo Jet Center LLC · Fargo, NDN813PKN813pk LLC · Columbia, MON814CAChristiansen Aviation LLC · Wilmington, DEN814EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN814FARivinius Sam · Danville, CAN814FGRidgeline Assets LLC · Wilmington, DEN814HAIasco Flight Training Inc · Redding, CAN814KSFargo Jet Center LLC · Fargo, NDN814MVSterling Flight Training LLC · Jacksonville, FLN814SAMarion Military Institute · Marion, ALN814WMLannom John Rusty · Lebanon, TNN815CPCivil Air Patrol · Maxwell Afb, ALN815CTCoast Flight Training And Management Inc · San Diego, CAN815DZBlue Sky LLC · Overland Park, KSN815EREmbry-Riddle Aeronautical University · Daytona Beach, FLN815KSPenner Bruce Wade · Hot Springs, SDN815SPPlane Fun Inc Tr Trustee · Snellville, GAN816ARCustom Curb Inc · Ventura, CAN816CPCivil Air Patrol · Maxwell Afb, ALN816EPFlight Leasing Corp · Wilmington, DEN816EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN816FSouthwest Aviation Enterprises · Haslet, TXN816FATemm 2000 Inc · Arcola, ILN816HAAtp Aircraft 4 LLC · Wilmington, DEN816JHIndy Aviation LLC · Carmel, INN816KSKansas State University · Salina, KSN816KWChristiansen Aviation LLC · Wilmington, DEN816PTPrudence Aviation Group · Fort Worth, TXN816RDHoffman Aeronautics LLC · Sedalia, CON816SWUniversity Of Alaska Anchorage · Anchorage, AKN816TRGood Day Holdings LLC · Sheridan, WYN817CPCivil Air Patrol · Maxwell Afb, ALN817EPTextron Aviation Inc · Wichita, KSN817FGRidgeline Assets LLC · Wilmington, DEN817HAIasco Flight Training Inc · Redding, CAN8182TMesa Aviation LLC · Brookings, SDN818ARLandsworth Corp · Monterey, CAN818CPCivil Air Patrol · Maxwell Afb, ALN818DUPrescott John E Jr · Tempe, AZN818EPEpic Aviation Inc · New Smyrna Beach, FLN818EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN818KARno Flyers LLC · Reno, NVN818SMMainardi William · Lincoln Park, NJN818SPN818xp LLC · Charleston, SCN818TSTextron Aviation Inc · Wichita, KSN819CFParlor City Flying Club Inc · Bloomsburg, PA
Back to AD 2003-24-13