AD 96-10-01 R1
Registered aircraft · 8,139
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:96-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
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:96-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1') 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.
N7754NSan Juan Flyers Inc · Pagosa Springs, CON7754WMartin Travis James · Gladewater, TXN7756NSiegler Dylan Benjamin · San Mateo, CAN7757NArmbruster Paul A · North Ridgeville, OHN775PCMsb Aircraft LLC · Statesboro, GAN775XHurst Thomas W · Broken Arrow, OKN7761NRutter Matthew T · Arcadia, OHN7762NRegistered aircraftN7762WHenson Russell K · Santa Fe, NMN7763NWever Marcus L · Lincolnton, NCN7763WSanchez Alyse Marie · San Antonio, TXN7765WTri-City Aviation Inc · Hopewell, VAN7766NKenealy Ian Patrick · San Rafael, CAN7766WBair Dale Leroy · Canton, OHN7767WFinan Kevin P · Seattle, WAN7768NLeap Frog Aviation LLC · Bentonville, ARN7768WKilo Niner Aviation LLC · Saint Petersburg, FLN7769NWoolsey Bradley W · Burleson, TXN7769WSeverson Michael A · Nampa, IDN7770CMcgee Ronald S · Waco, KYN7770NThompson Brad J · Pleasant View, TNN7770WN7770w LLC · Sheridan, WYN7771NSale Reported · Copper Center, AKSale reported, pending cancellationN7771WWhitman Edward G · River Falls, WIN7772CCummings David P · Grayson, LAN7772NZmq Aviation LLC · Minneapolis, MNN7773NDmac Aircraft LLC · Savannah, GAN7773WVida Kenneth J · Harrison Township, MIN7774NRai Jeff · Nazareth, PAN7775NHarris Mark · Greenville, SCN7776NSkylark Flight Training LLC · Wilmington, DEN7777WAmmon Roadable Aircraft LLC · Manchester, NHN7778NAsari Investments LLC · Knoxville, TNN7779NPhyxsius Aviation LLC · El Paso, TXN7779WHolowatsch Sergio O · Archer, FLN777KCWing It LLC · Carlisle, IAN777SRWilkie David J · Nashua, NHN777VXGutierrez Ruben E · Fontana, CAN777WBClark Lloyd E · Hanover, MDN7781NKns Asset Management LLC · Lumberton, TXN7782WDavies Kenneth A · Oak Harbor, WAN7783NForbes Aviation LLC · Boise, IDN7784WHarding Robert L · Nine Mile Falls, WAN7785NMorning Aviation LLC · Altoona, PAN7786NPearson Derek E · Rockwell City, IAN7786WRoger Dodger Vector Victor LLC · Fort Myers, FLN7787NBarker Lynn Harvey · Sylmar, CAN7788NZwickel Claire · Catskill, NYN7788WRichards Adam R · Mesa, AZN7789NAntaya Adam N · Lakeland, FL
Back to AD 96-10-01 R1