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.
N55605Parrish Don A · Plains, TXN55606Falcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedN55608Thunderbird Aviation LLC · Shawnee, OKN5560FVandyke Jason M · Gettysburg, PAN55617Critchett Reggie D · Sterling Heights, MIN55618Keller Paul D · Burlington, CTN55621Wood Steve · Fresno, CAN55622Detor Properties Inc · Rochester, NYN55623Vector Aviation Services LLC · Groesbeck, TXN5562FTom Brian A · Santa Clarita, CAN5562UWilkosz Robert · Tampa, FLN5563UBlair James S · Beltsville, MDN55640Adams Charles G III · Tawas City, MIN55646Bluto Paul · Branson, MON55648Pic Aviation Inc · Bloomsburg, PAN5564FVazquez Oscar C · Moreno Valley, CAN5564UGoldinger Matthew L · Ligonier, PAN55656Denovellis Dennis T · Sidney, NEN55659Beiderman Allan R · Melbourne, FLN5565FHenley Brett · Manchester, TNFirst renewal noticeN5565UFiebich Stephan C · Kearney, MON55667Stanick Paul J · Whitinsville, MAN5566UKingsbury Janet L · Miramar, FLN5566WRegistered aircraftN55671Brown Christopher A · Tigard, ORN55673Smith Gordon H · Racine, WIN55675Sykes Kinsley · Palm Coast, FLN5567W3k Weavers Investment Group LLC · Shelbyville, KYN55680Madsen Pest Management LLC · Siren, WIN55687Rieber Russell C · Stockton, CAN5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationN55691Brown Alan · Lugoff, SCN5569UJapikse Bert · Pawleys Island, SCN5569WBridges Michael D · Clovis, NMN556FLKarg Asset Management LLC · Pocahontas, ARN556PAAviator Corp · Wilmington, DEN55701Level Up Aviation LLC · Newton, ALN55702Seay Horace M · Desoto, TXN55706Camp Justin P · Edwall, WAN5570FCherokee Adventure Corp · Wilmington, DEN5570URegistration Pending · Mesa, AZRegistration pendingN55715Ricker Alexander · Spur, TXN55716Norby Aviation LLC · Hopkinton, MAN55719Coffey County Airport · Burlington, KSN55722Cactus Aero LLC · Haslet, TXN55724Parker David G · Bristol, TNN5572UPoor Farmer Aviation LLC · Saint Marys, OHN5572VWood Charles S · Fox Island, WAN55730K&D Ip LLC · Chicago, ILN55731Leary Dennis E · Chesapeake Beach, MD
Back to AD 96-10-01 R1