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.
N55736Fox Ralph W II · Wilmington, NCN55738Wenner William E · Kechi, KSN55739Kepfer Robert · Felton, DEN5573WHokanson Elijah R · Ashby, MNN55742Doyal William T · Visalia, CAN55743B&R Aircraft LLC · Wadsworth, OHN55744Williams Mike · Hartsville, INN55746Mccoy Michael E · Sanford, NCN5574UCooper Nicholas A · Plano, TXN5574WNordell Ryan J · Roberts, WIN5575FBrewington Jesse L · Glenallen, MON55761Ramirez Ramon E · Boynton Beach, FLN55769Urban Joseph P · Ben Wheeler, TXN5576UChambers Luther · New Philadelphia, OHN5576WKoch Christopher P · Batavia, NYN55771Christman Timothy J · Stillwater, MNN5577FFederici Susan L · Vineland, NJN55780Sibayan Jose E · Lutz, FLN55783Djh Leasing LLC · De Pere, WIN55785La Grange Aviation LLC · Bolingbrook, ILN5578UHolmes Robert G · Jacksonville, FLN5578WVigano Davide · Redmond, WAN55790Buzzard Aviation LLC · Pace, FLN55792Ramocinski Carson · Prescott, AZN5579FSeaplane Adventures LLC · Cheyenne, WYN5579UInternational Air Services Inc Trustee · Carson City, NVN557SWMarshall John F III · Sterling Heights, MIN55801Jacobs Michael A · Modesto, CAN55802Thomas Tommy A · Garden Grove, CAN55803Georgoulianos Anthanasios · Sweetwater, NJN55808Oltrogge Michael · Bancroft, NEN5580WSmitty 172 LLC · Rockford, MIN55811Scott Tyler C · Ball Ground, GAN55816Flying Manatees LLC · Wilmington, DEN55818Lovejoy Aviation LLC · Cato, NYN5581WRay Justin P · Centre, ALN55823Steele Lawrence D · Belleair Beach, FLN55824Ray Foster Stephen · Stockton, CAN55827Debonis Nicholas Michael · Woodland, CAN5582UPatterson Saralyn · Oklahoma City, OKN5582WRieger Karen M · Indianapolis, INN55838Hintenlang David · Archer, FLN5583FAiken Pilot Training LLC · Johnston, SCN55840Walko Michael E · Scotch Plains, NJN55842Ansboro James C · Goshen, NYN55844Cozby Charles L · Wellsboro, PAN5584FGuiliano Anthony · Tobyhanna, PAN5584WDill Mark B · Amarillo, TXN55852Ingold Terry L · Albemarle, NCN5585FSouth Texas Air Force LLC · Mission, TX
Back to AD 96-10-01 R1