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.
N7007WBiros Timothy D · Nya, MNN7008RPerchall Theodore G II · Fort Myers, FLN7009RJackson Donald W · Carthage, MSN700FMWahl Mark E · Oswego, NYN7010WBrown Nicholas R · Knoxville, TNN7011WLevine Allen D Trustee · Goshen, NYN7012RPalomo Joe · Laredo, TXN7014WSpi Group LLC · Georgetown, TXN7015WHunt Timothy J · Mesa, AZN7016WDoorenbos Rodney J · Washburn, MON7017RRd Aire LLC · Opelika, ALN7017WLong Matt · Watsonville, CAN7018RMccauley Lauren M · Severance, CON7018WArnold Richard C · Fitchburg, MAN7019RMidland Flyers LLC · Warrenton, VAN701DTWilliamson Flying Club Inc · Williamson, NYN701FLInternational Air Services Inc Trustee · Carson City, NVN7020RJwe Aviation LLC · Sugar Hill, GAN7020WDavila Antonio · Cudjoe Key, FLN7021WRichardson Garrett W · Mason, MIN7022WHall Wesley B · Hot Springs, ARN7023RPushpull LLC · Montgomery, TXN7025WBerberich Edward C · Gillette, NJN7026RSanderson Eric R · Chelan, WAN7026WAdvanced Aviation Inc · Lakeville, MNN7028RCuckler Jason Michael · Jenks, OKN7028WBlakely Richard S · Yerington, NVN7029RBazzi Adel · Yorba Linda, CAN7029WUSA Aircraft Leasing LLC · Dover, DEN7030RAlpha Kilo Aviation LLC · Wasilla, AKN7031WEarl Hittle Aero Inc · Greenville, OHN7032WFleming William P · Tomah, WIN7033FNaugler Winsor III · Fort Washington, PAN7033WRegistered aircraftN-number assigned, not yet registeredN7034RMacallen Chemical Inc · Monroe, LAN7034WCooke Riley O · Bridger, MTN7035WJerome Jeffrey A · Conneaut Lake, PAN7036WArizona Flying Pigs LLC · Flagstaff, AZN7037RJames Jerome A · Sioux Falls, SDN7038RElite Aircraft Services LLC · Pierce City, MON703EADerrick Engineering Inc · Louisville, KYN703FLRalls W A · Idabel, OKN703TKLorimar Group Inc · El Cajon, CAN7040RDavies Lori M · Gainesville, TXN7040WDemaagd Ross E · Middleville, MIN7041CWayman Christopher Paul · Hyde Park, NYN7041WRoth Isaac J · Ontario, WIN7043RHolst Thomas C · Pleasant Hope, MON7044RSalzer Vaughn R · Ashley, NDN7045R509 Aviation LLC · Lewes, DE
Back to AD 96-10-01 R1