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.
N4441JPinkston Lance C · Batesville, ARN4442XHayes Kevin R · Richmond Hill, GAN44430Red Eye Aviation LLC · Minocqua, WIN4443TKristofzski John · West Richland, WAN44442Cummins Stephen Michael · Fenton, MON44450Brown Roy A · Morongo Valley, CAN44452Cdr Aviation LLC · Kalispell, MTN4446JScherr Steven · Mandan, NDN44478Richard J Farmer II · Fremont, OHN4448THoughton John L · Lamar, MON44497English William E · Mason City, IAN4449JSinatra Anthony J · Glendale, AZN444JLColby Christopher F · Hampton, VAN444KCEdelman Douglas M · Sabetha, KSN444LMHumphrey William E · Lyndonville, VTN44502Kartman Dennis J · Verona, WIFirst renewal noticeN44507Bebout Stuart Lee · Chapmansboro, TNN4450JBao Yucai · Andover, KSN4450TMatt Houchin Holdings LLC · Middletown, OHN44511Sevier County Choppers Inc · Sevierville, TNN44512Almond Wayne · Edgewater, FLN44514Taylor Clarence J · Pipestone, MNN44518Jsp Aviation LLC · Wauconda, ILN44519Schroeder Craig L · Tipton, IAN44524Cosklo Scott C · Clifford Township, PAN44528Flywerx LLC · Anchor Point, AKN4452JFly Around Alaska LLC · Palmer, AKN44530Wycoff Ryan · Watauga, TXN44534Sale Reported · Keystone Heights, FLSale reported, pending cancellationN44546Polka Todd M · New Philadelphia, OHN4454JEvans Craig · Bastrop, LAN44553Murrell Stanley D · Alabaster, ALN44556Sayonara Air LLC · Old Hickory, TNN4455TK-T Customs LLC · Mustang, OKN44575Fit Overflow LLC · Davidson, NCN44584Boomerang Air LLC · Cedar Park, TXN4458JMillan Sanchez Omar · Sussex, NJN44590Lee John Michael · Van Nuys, CAN44597Tob Cherokee Flyers · Kasson, MNN4459JCoastal Virginia Aviation LLC · Chesapeake, VAN44604Lydic Daniel · Pittsburgh, PAN4460TRuff Randall N · Bay City, MIN44614Swair LLC · Denver, CON4461JBoyd Eric L · Stuart, FLN4463JFlying Hawks Inc · Palmyra, WIN44647Forster Aero LLC · Kaukauna, WIN4464JVeltri Laura D · Kismet, KSN4464XDetor Properties Inc · Rochester, NYN44653Cash Management Consulting LLC · Granite Springs, NYN4465JDietrick Roy G · Humboldt, NE
Back to AD 96-10-01 R1