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.
N516CR516 Ontario Capital Holdings LLC · Hartland, WIN516EVAerofly Procurement LLC · Owasso, OKN516SRLdw Enterprises LLC · Loretto, TNN5175FBroomstick Aviation LLC · Fairfield, IAN5175LAsb Industries LLC · Driggs, IDN517CDPeker Lev M · Sylmar, CAN517CPInformation Management Systems Inc · Madison, MSN517LMSoaring Paws Aviation LLC · Dickinson, NDN517PZPapa Zulu LLC · Bend, ORN517SWStarship Aviation LLC · Northville, MIN518AWN All Cirrusness LLC · Lake Charles, LAN518BADalton Wholesale Floors Of Gordon County Ga Inc · Adairsville, GAN518BPDr James Loging Md LLC · Prosperity, SCN518CDCornerstone Auto Parts LLC · Pratt, KSN518CPDdr Enterprises LLC · Kodak, TNN518FDCirrus Design Corp · Duluth, MNN518LMResnik Robert · Scottsdale, AZN518MDGreens Aviation LLC · Lebanon, OHN518VAN518va LLC · Latham, NYN519BRSilver Train Management LLC · Raleigh, NCN519CBMidwest Liquidation LLC · Grand Meadow, MNN519DENiner Delta Echo Inc · Milton, DEN519DHDavis Steven Jeffry Trustee · Poway, CAN519SRSale Reported · Seneca, SCSale reportedN519WVRegistered aircraftN51CWAviation Enterprises LLC · Bath, MEN51LAKrauss Elliot A · Princeton, NJN51XJKalm Skies LLC · Mobile, ALN520BCMitchell Bruce P · Medford, ORN520CLRobo Holdings LLC · Tampa, FLN520WKOld Landing Aviation LLC · Great Falls, VAN521BTBennett Brady R · Pinehurst, NCN521CDSale Reported · KasselSale reportedN521HWCirrus Design Corp · Duluth, MNN521LCRegistered aircraftN-number assigned (import), not yet registeredN521LMTavallaee Mehrdad M · Ashland, OHN521TSJustice William F · Calabasas, CAN521ZHoffner Flying Inc · Yankton, SDN521ZMThompson Russell Clayton · Hartland, MIN5226RBuncamper Theodore · St MaartenN522ACrowe Aviation LLC · Vestavia, ALN522ARMedic Choppers LLC · Springdale, ARN522CDFbm LLC · La Porte, INN522CPFly Cirrus LLC · Murrieta, CAN522DDHw Aviation LLC · Largo, FLN522DXFd Aircraft LLC · Summit, NJN522FDCirrus Design Corp · Duluth, MNN522KGJdi Electrical Solutions Inc · Temecula, CAN522MGParker James V · Cashiers, NCFirst renewal noticeN522PUFlying Club LLC · New York, NY
Back to AD 2007-24-13