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.
N27WVN27wv LLC · Shortsville, NYN2801LAv8sgf LLC · Rogersville, MON280CDWelling Lynn E · El Cajon, CAN280CPAi Aviators LLC · Vancouver, WAN280LVagiunic David · Ridgewood, NYN280SREdge Forward LLC · Thermopolis, WYN281CPJust Plane Insane LLC · Missouri City, TXN281DSBoughton Kyle · Mckinleyville, CAN281MFFisher Robert · Durham, NCN281SRLawyers Real Estate Services LLC · Hondo, NMN282Sh1p Holdings LLC · Wichita, KSN2824MDodson International Parts Inc · Rantoul, KSN282CBWhisky Tango LLC · Hendersonville, TNN282CDAurora Partners LLC · Oregon City, ORN282DJViva LLC · Dover, DEN282DMSkyshoe II LLC · Beverly, MAN282EEFogprop N282ee LLC · Bolinas, CAN282THAero Sky Inc · Terrace Park, OHN2834YAvance Aircraft LLC · Wilmington, DEN283DDMosier Don · Stanford, KYN283SRArtemis Aviation LLC · Mondovi, WIN283WTBlue Nexus LLC · Lewes, DEN284CDOld Hickory Flyers · Franklin, TNN284CTCirrus Design Corp · Duluth, MNN284LMB-Airborne LLC · Woodbine, MDN285KAGtb Aviation LLC · Seattle, WAN285WT285wt LLC · Wilmington, DEN286AKDog Island Air Inc · Wilmington, DEN286BBBell Family Cirrus LLC · Louisville, KYN286FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN287CPAlves Philip · Sandy, UTN287DSCustis Cirrus Aviation LLC · Birmingham, ALN287THTh Aviation LLC · Savannah, GAN288MJRocky Ford Leasing LLC · Tallahassee, FLN289EMorrison Matthew J · Waco, TXN289SBHemcka Aviation LLC · Bradenton, FLN28BKMooster Aviation LLC · Niceville, FLN28BXBoyle Brendan C · Apex, NCN28FNValiair Lc Trustee · Casper, WYN28NWFixed Gear Sportsman LLC · Seattle, WAN28TKLos Cielos Flyers LLC · San Antonio, TXN290JCirco Industries 2 LLC · Belle Chasse, LAN290SRAvodah Management LLC · Kalispell, MTN290WABlue Yonder LLC · Paris, TNN2914YBol Aero LLC · Beverly Hills, CAN292CDContrails Aviation LLC · Minneapolis, MNN292DRDouble R Aviation LLC · Dallas, TXN292SRFogle & Sons Electric LLC · Columbia, SCN293LMDelta Delta Papa LLC · Fort Lauderdale, FLN293SRSykes Robert G · Hopkins, MN
Back to AD 2007-24-13