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.
N55XFCeb Enterprises LLC · Petal, MSN56007N56007 LLC · Burke, VAN56008F R G III Inc DBA · Lincoln Park, NJN5600UCorey Marlin F · Choctaw, OKN5600WFitzgerald Anthony M · Crete, NEN56015Ac Sales & Investments LLC · Hickory, NCN5601WTaylor Larry J · San Manuel, AZN5602WSaunders Nathaniel E · Muskegon, MIN5603WElliot Harold F II · Pomeroy, OHN56041Haddad Joe · Charlotte, NCN5604UShumaker Grant H · Dakota Dunes, SDN5604WHustedde Trucking LLC · Fayette, MON56055Murray Patrick Calvin Jr · Port Orchard, WAN5605UN5605u LLC · Nottingham, NHN5605WHammack Tyler S · Brush Prairie, WAN5607UWilliams Richard Dale · Tucson, AZN5607WFrost Jack D II · Goodrich, MIN56083Rock Solid Aviation LLC · Lake Charles, LAN5608USchoenberger Amber J · Niceville, FLN56090Wood William J · Jackson, GAN56098Wong Yi C · Aurora, CON5609USteves Landavator Service LLC · Oley, PAN560FLBancroft Robert W · Aurora, NYN56105Anderson Wendell R · Brainerd, MNN5610UAnderson Aviation LLC · Bulverde, TXN56119Button Eric T · Austin, TXN56125Upstate Flying Club Inc · Marcy, NYN56126Moore Holdings LLC · Janesville, WIN56134Buxton Richard L · Boise, IDN56136Weed Brian Jeffrey · Omaha, NEN5613UAviation Trust Company LLC Trustee · Oklahoma City, OKN5613WHocking Terry G · Nashwauk, MNN56140Lets Fly Az LLC · Scottsdale, AZN56149Lets Fly LLC · Albemarle, NCN5614WColeman John H · Jackson, MIN56158Munyon William · Vineland, NJN5615WH&H Aviation LLC · Lehi, UTN56160Thatcher Michael · Delaware, OHN56161Ohmart Jeffrey A · Wichita, KSN5617UManagement Company Of South Carolina LLC · West Columbia, SCN5617WRose Dean R · Appleton, WIN56182Gerst Peter C · Williamsport, PAN56190Bertch Gary M · Waterloo, IAN56198Holden James R Jr · Milton, GAN5619WIsbell David Myles · Tucson, AZN561FLOnwe Edward E · San Antonio, TXN56201Kaney Howard W · West Bend, WIN56202Kunze Paul C · Tempe, AZN56204Andreas Charles V · Neenah, WIN5621UMeinert Kyle L · Cottage Grove, WI
Back to AD 96-10-01 R1