AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N83295Steffey Charles S · Raleigh, NCN8329VBuck Timothy A · Howland, MEN83300Dennis John Mark L · Paola, KSN83303Rackley Steven P · Livermore, CAN83304Lorenz Brian J Trustee · Ballwin, MON83308Clinton Richard C · Fair Oaks, CAN83309Del Martin Lp · Spring, TXN8330VJensen Carla J · Pingree, IDN83311Ballard Alexander Jr · Conneaut Lake, PAN83314Hampton Michael D · Marshfield, MON83317Hughes Michael C · Wasilla, AKN83318Miller Richard E · Philip, SDN8331VAirplane Binnis LLC · Janesville, WIN83320Lynn Lonnie A · Jesup, GAN83321Lovern Steven B · Newton, NCN83322Mister Jonathan · Roaring Spring, PAN83323Kijowski Thomas C · Freeport, PAN83327Olear Inc · Evansville, INN83333Chipman Jeff M · Rising Sun, INN83336Pease Gordon W · Hampden, MEFirst renewal noticeN83340Brekhus Susan Marie Wissler · Tenino, WAN83341Herridge Douglas E · Tacoma, WAN83342Cummins Michael V · Modesto, CAN83348Miller Sean C · New Carlisle, OHN8334VRegistration Pending · Milton, FLRegistration pendingN83352Deckard Audie T · Independence, ORN83355Krueger Steven A · Merrill, WIN83357Mcginn Robert W · Marion, NCN8335VLisoski Derek L · Clark Fork, IDN83360Sankey Paul F · Colusa, CAN83361Maynard Mark L · Kendall, NYN83363Van Bergen Mark S · Soquel, CAN83366Texas Warbirds LLC · Lewes, DEN83369Bellamy John-Mark · Freeville, NYN8337VWydronek Joseph A · Tucson, AZN83385Nelson William J · Mahnomen, MNN83387Goodwin Richard L · Northfield, MNN83388Grubs Jon P · White Bear Lake, MNN83389Snyder Michael Scott · Erie, CON8338VGustafson Cody A · Corvallis, ORN83391Abbe Thomas E · Wasilla, AKN83393Jasinski Jack J · Necedah, WIN83399Latimer Francis E · Washingtonville, NYN83401Macario Mark A · Weirsdale, FLN83405Banner Bernard C Jr Trustee · Lawrenceburg, INN83406Epps Edward A · Texarkana, TXN83407Travis Johnathan M · Griffin, GAN83409David P St George · Ithaca, NYN83410Peters William D Jr · Charleston, WVN83414Higgins Bennett P · Brewer, ME
Back to AD 2000-25-02 R1