AD 2007-24-13
Registered aircraft · 4,026
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:2007-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:2007-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:2007-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:2007-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.
N763LSJaybird Aviation LLC · Many, LAN765CTBim Jett LLC · Sacramento, CAN765GMFacts Holdings Inc · Clearwater, FLN766ATAdvisoar LLC · Jacksonville, FLN766SBAirhawk2 LLC · Cannon Beach, ORN7677DSteel Aviation Inc · Phillipsburg, OHN767ZZRegistered aircraftN768CDSears William R · Lexington, MAN769CDSutherland James N · Terrebonne, ORN769KVFalcon Aviation Inc · West Jefferson, OHN769SROwll Aviation LLC · Baton Rouge, LAN76ALAldeen Leo · Houston, TXN76AVCirrus Design Corp · Duluth, MNN76BYViper Aeronautics LLC · Lincoln, NEN76SVParish Aviation LLC · New Orleans, LAN770CAHorse Hill LLC · Napa, CAN770CTMetza M Kristen · Andrews, NCN770MMButterworth James Blakely · Demorest, GAN770SRRiverside Aircraft LLC · Fort Myers, FLN770TPJekkerson LLC · Evergreen, CON771BTRosen Air 71 LLC · Brentwood, TNN771KSWieczorek Michael A · Athens, GAN771SL3vr Aviation LLC · Annapolis, MDN771SRN771sr Inc Trustee · Wilmington, DEN772CManitoba Pacific LLC · Laguna Niguel, CAN772CCWagner William · Oro Valley, AZN772CDHarllee Cattle Company LLC · Bradenton, FLN773ABCirrus Aviators LLC · Leesburg, VAN773BBMinnesota Made Hockey Inc · Edina, MNN773CDMississippi Pepin Flyers LLC · Hager City, WIN773CVRengel & Co Architects Inc · Tustin, CAN773DCFlying Rose LLC · Sparks, NVN773DVDuet Ventures LLC · Isle Of Palms, SCN773SRTiger Eye 2004 LLC · Montauk, NYN774CDValiair Limited Co Trustee · Casper, WYN774EBBruce Erik · Yreka, CAN774SRLevesque Jay F · Rochester, NHN774TRMb Air Inc · Fort Myers, FLN775CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN775EWThree Three Foxtrot Inc · Cedar Falls, IAN7763BWyndymere Harbor LLC · Port Saint Lucie, FLN7763YBen Shuzen LLC · White Plains, NYN776CDTriple Crown Aviation LLC · Las Vegas, NVN776PMHoudashell Investments LLC · Amarillo, TXN7773HCirrus 7773h LLC · Wilmington, DEN7774ZLaw Office Of Yossi Noudel · Encino, CAN777AJV-R Holdings LLC · Sauget, ILN777CL777cl Aviation LLC · Sheridan, WYN777GBFc Sr Capital LLC · Anaheim, CAN777GVPerry Robert A · Tucson, AZ
Back to AD 2007-24-13