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.
N5088QMetro Aircraft Co · Bloomington, MNN508ACKtaz Air LLC · Niceville, FLN508FGRidgeline Assets LLC · Wilmington, DEN508NDCorsair Aviation LLC · Pacoima, CAN5096CMetro Aircraft Co · Bloomington, MNN509ATPollard Weldon Luke · Ardmore, OKN509EREmbry-Riddle Aeronautical University Inc · Prescott, AZN509FGMustang Sally Aviation LLC · Camden, SCN509NDPhoenix East Aviation LLC · Daytona Beach, FLN509SPScandinavian Aviation Academy Inc · El Cajon, CAN509TAN509ta-Ln LLC · New Braunfels, TXN50RFFecteau Robert · Taylorsville, NCN50SUOhio State University · Columbus, OHN50TGTgi On-Top LLC · Woodland, CAN50VVVictor Victor Leasing LLC · Pompton Plains, NJN5100XSmith Ronald N · College Station, TXN5101UMichigan Department Of Natural Resources · Roscommon, MIN5103NGulf Coast Helicopters Inc · Pearland, TXN5107NChristiansen Aviation LLC · Wilmington, DEN5107YBrown Peter B · Salem, VAN51096Dept Of The Interior · Boise, IDN510KSNational Aircraft Leasing Corp · Greenville, DEN510LPSouthern Cross Aviation LLC · Parker, AZN510NDSunrise Aviation Inc · Ormond Beach, FLN510SLBeery Roofing & Redesign LLC · Deland, FLN510TRAltamira Flying Club Inc · Round Rock, TXN5114JGates Joanne L Trustee · Pittsburg, TXN5114ZMustang Sally Aviation LLC · Camden, SCN5115BWateractive43 LLC · Auburn, CAN51163Christiansen Aviation LLC · Wilmington, DEN5116BQuantum Aviation LLC · Manchester, MDN51198Registered aircraftN511DWD.B. Wood LLC · Levering, MIN511EREmbry-Riddle Aeronautical University Inc · Prescott, AZN511HPPattison Aero Inc · Henderson, NVN511NDSunrise Aviation Inc · Ormond Beach, FLN51216US Department Of Homeland Security · Washington, DCN5122UChristiansen Aviation LLC · Wilmington, DEN5126JGull Rock Aviation LLC · Punta Gorda, FLN5127WRegistration Pending · Kalispell, MTRegistration pendingN51282Registration Pending · West Point, NERegistration pendingN512CTCoast Flight Training And Management Inc · San Diego, CAN512DPCanal Aviation LLC · Dover, DEN512ERTextron Aviation Inc · Wichita, KSN512FGLcb Leasing · Bristow, VAN512NDCoast Flight Training And Management Inc · San Diego, CAN512SPAvolant Aviation LLC · Mooresville, NCN5130FC & M Dreamflights LLC · Mount Pleasant, SCN51313Echo Tango 03 LLC · Anthem, AZN51325Baldwin Gordon Lee Jr · Altamonte Springs, FL
Back to AD 2003-24-13