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.
N7163WWings Over Lake Norman LLC · Mooresville, NCN7164RGurley Brian M · Norman, OKN7164WShort Final Aviation LLC · Branson, MON7166RRagains Frank H · White House, TNN7166WWhitney Albert C · Mission Viejo, CAN7167RPriewe Jeff C · Como, MSN7167WBuckley Barney P · Colfax, WAN7168RParham Maxwell V · Madison, MSN7168WDestination Flyer LLC · Memphis, TNN7169RBrock Charles Calvin Jr · Pendleton, SCN716RHPowers Alan J · Fayetteville, GAN716RLPerguson Robert Cole · Converse, TXFirst renewal noticeN7170RBrown Joshua A · Fayetteville, GAN7170WMontana Thomas · Port St Lucie, FLN7171RYoungblood Steven H · Gilmer, TXN7172WSkrypai Vladislav · Poplar Grove, ILN7173WCastro Joaquin H · Wellington, FLN7175RElks Virginia L · Chocowinity, NCN7177RSandifer Darian A · Speedwell, TNN7178RBronson Erin William · Emmett, IDN7178WSnyder Michael P Jr · Reno, NVN7179RIfly Aviation LLC · Ephrata, PAN7179WSummit Concepts LLC · Five Points, ALN717ARJones Joshua W · Hudson, MAN717FLNorth Texas Aeronautics LLC · Burleson, TXN7180RKostas Kaounas · Brookings, SDN7181WIowa Technology Solutions LLC · Manson, IAN7182RStl Aviation LLC · Mchenry, ILN7182WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7183RNorton Charles · Coon Valley, WIN7185RThain Paul K · Davenport, FLN7185WHerriman Alan · Durham, NCN7186WHendrix Gregory K · Lindon, UTN7188WEchoaviation Holdings LLC · Akron, OHN7189RPlymale Winston Leigh Jr · Salem, VAN718FLTubesing Gordon E · Palm Coast, FLN7190RChristopher Ralph K · Weedsport, NYN7190WAndros Aviation LLC · Santa Margarita, CAN7192WPope Larry · Lake View, NYN7194RAltair Associates · Middletown, DEN7194WWagner Jeffrey P · Bridport, VTN7195WMueller Reinhard B · Sparta, WIN7196RCrisler Capital LLC · Sunnyvale, TXN7197RTaylor Timothy T · Quitman, ARN7198RWest Michigan Flying Club Inc · Norton Shores, MIN7199RBrendemuhl Nathan C · Everett, WAN7199WBobkat Aviation LLC · Louisville, KYN719FLMendoza Fernando · Hialeah, FLN719MRJts Aircraft LLC · Rock Hill, SCN71AKWhittlesy Harold A · Anchorage, AK
Back to AD 96-10-01 R1