AD 98-24-07
Registered aircraft · 193
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:98-24-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-24-07')
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:98-24-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-24-07') 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.
N101EXMeyer Chad A · Whittemore, IAN102EXWoods Farrell T · Hudson, NHN102JKRockstar Aviation LLC · Cresson, TXN105MMNorth Star Aviation Inc · Mankato, MNN111XTPatch Aero LLC · Boca Raton, FLN111XWUnited Air LLC · Walnut Creek, CAN119DBWalker John D · Neosho, MON125EXWurster Gregory J · Creston, IAN129SJWorking Capital Group LLC · Rogers, ARN133DFMohn Michael A · Scottsdale, AZN136SMMartens Aerosports LLC · Garden City, NYN13EXPitts Capital Of Nevada Inc · Las Vegas, NVN13PRTomlinson Dana R · San Angelo, TXN15FBPropit Inc · Wilmington, DEN161FCAps Asset Management Inc · Mesa, AZN162FCSanders Racing Inc · Jasper, ALN164EXDrj Management LLC · Weston, CTN169DHDon C Hartmann Aircraft Sales LLC · Boynton Beach, FLN169EXFlying Squirrel Aviation LLC · Wilmington, DEN169MGeorge Michael · Springfield, ILN17NLAerospatial Systems LLC · Boulder, CON183EXFlying W Leasing Inc · Bartlett, ILN199RGBell Aviation Inc · Wilmington, DEN199XSugden Richard G · Wilson, WYN203EXAps Asset Management Inc · Mesa, AZN207LHSnaproll Inc · Wilmington, DEN207XBane Russell · Palm Beach Gardens, FLN213EXHalcyon Consulting LLC · Roseville, CAN214EXBaum Group LLC · Shavertown, PAN217EXMelnik Ventures LLC · Longwood, FLN21EXJones Thomas E · Crestline, CAN21XTVegas Extreme Adventures LLC · North Las Vegas, NVN224DRegistration Pending · Henderson, NVRegistration pendingN22EXIntriago Elisa M · Miami, FLN237HHatfield R Andrew · Grand Junction, CON23EXBaker Tim Y · Lafayette, LAN244JTMcgilvray Andrea · Bandera, TXN245EXBens Travel Gear LLC · Mountain Home, ARN247JNewman Fredric M · Birmingham, ALN249JHershorin Mason · Pembroke Pines, FLN24GAVehicle Holdings Inc · Las Cruces, NMN251ECMike Lima Partners LLC · Wilmington, DEN251RFAcadiana Fixed Wing Rotor Wing Inc · Carencro, LAN252RFRegistered aircraftN254RFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN255RFSoar International LLC · Olive Branch, MSN25APSowder Douglas A · Spokane, WAN25EXRegistered aircraftN25JXHold The Wind LLC · Lewes, DEN264EXFull Circle Aero LLC · Wilmington, DE
Back to AD 98-24-07