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.
N5910WMetz Tyler B · Bridgeport, WVN5911UMoore Air Inc · Honolulu, HIN5911WBrimmer Harold C · Longview, TXN5914UShawver Aviation LLC · Knoxville, IAN5914WSteadfast Avatiion LLC · Mesa, AZN5915UOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedN5915WTheobald Daryl · Aberdeen, SDN5916UForsman Airways LLC · Glenwood, MNN5917WHiggins James L · Harrisville, MIN5918WLathrop Patrick W · Kent, WAN5919UDewater Mark · Mulberry, ARN5920WSynergy Aviation LLC · Greer, SCN5921WStearns Edwin Ben Jr · Eloy, AZN5922UPagan Jose A · Kokomo, INN5923WPremier Pilots LLC · Herriman, UTN5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILN5924WPribbenow Dennis A · Payson, AZN5926UIron Flyer Of Cuzamil LLC · Lewes, DEN5926WLeonard Jeffrey A · Bakersfield, CAN5927WKochling Christopher · Houston, TXN5928WRegistered aircraftN-number assigned, not yet registeredN5929WEdwards Allan · Leesburg, VAN592FLGrey Rose Air LLC · Edenton, NCN5930USplendid Air Leasing LLC · Dover, DEN5930WGraham James C Co-Trustee · Bellville, OHN5931UJ And H Aircraft Leasing Inc · Palmyra, PAN5932URegistration Pending · Bulverde, TXRegistration pendingN5932WSchaaf Rodney B · Bowman, NDN5934WDear Stephen R · Pioneer, CAN5937WMikesell Lloyd L · Kokomo, INN5938ULame Duck Aviation LLC · Leesburg, INN5938WDewald Joseph L · Fort Wayne, INN5939WPhillips Morris · Decatur, GAN593FLEmpire Aviators LLC · Long Island City, NYN593SPFull Rudder Flyers LLC · Mesa, AZN5940UStrong Colin · Portland, ORFirst renewal noticeN5941WCunningham James R · Collierville, TNN5943URoth Larry · Marion, IAN5943WSallee Steven A · St George, UTN5944WFerguson Robert C · Cornelia, GAN5945WHensley Roger A · Rosamond, CAN5946UBlack Howard J Jr · Bethpage, TNN5947WPierce Colby · Midland, TXN5949U5949 Inc · Boulder City, NVN5949WSutton Warren L · Loris, SCN594SPFrench David J · Aptos, CAN5950WRegistered aircraftN5951ULink David R · The Dalles, ORN5952USlocombe Walter B · Bossier City, LAN5953WDavis Kyle G · Waseca, MN
Back to AD 96-10-01 R1