AD 2000-04-26
Registered aircraft · 77
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-04-26')
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-04-26')
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-04-26') 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-04-26') 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.
N108WRHallett Mark R · Hobe Sound, FLN127FPFoertsch Eric R · Acton, MAN127KSDeutsch Mitchell M · Marietta, GAN127LJRedweik Eric P · Tucson, AZN127MGMichalowski Roman · Eastchester, NYN127MMRoach Brian L · San Jose, CAN127PADowell Christopher W · Palmdale, CAN127PRCedar Richard D · Cincinnati, OHN127RJDavid James R Jr · Franconia, NHN127SM27 Bravo LLC · Saint Paul, MNN137EDUrbanczyk Kirk M · Draper, UTN19HKCarter Gary E · Dahlonega, GAN227BBDerosa John H · West Dundee, ILN227DWDutka Leslie A · Pittsburgh, PAN227MGRegistered aircraftRegistration pendingN227SDMinar Steven H · Bend, ORN22SQMertins Enrique · Parrish, FLN2611WEiler Martin J · California City, CAN270ASWeck Geoffrey E · Woodstock, ILN271JHSchmidt Mark A · San Marino, CAN271JSArmstrong Daniel J · Tehachapi, CAN2727BZelek Daniel · Wurtsboro, NYN272JSRuf Chris J · Sandy Springs, GAN272PCHilty Grant C · Prescott Valley, AZN273SPRiley Thomas V · San Diego, CAN274CEHawkins Mark F · Edgewood, NMN274JMLarimore Stuart B Trustee · Boise, IDN274RDPillard Russell L Jr · Santa Rosa, CAN274RTSchaefer Rich · Marble Falls, TXN274SPRoettele Mark S · Yorba Linda, CAN279VTKozak Andrew A · Brownsville, VTN27BUJones Philip Trustee · Carson City, NVN27BZN27bz LLC · Decatur, GAN27CEMccarthy Evan · Irvine, CAN27FSCarden Eric · Huntsville, ALN27GLMcmaster Justin Thomas · Winterhaven, FLN27HFSawyer Tyson David · Mason, NHN27HHWaitekaitis Steven M · Norwell, MAN27KHEvenski Linda G · Honeoye, NYN27KTGardner Timothy J · Gardnerville, NVN27SNYoungblood Robert W · Vero Beach, FLN27UHBohl Howard M Jr · Long Beach, CAN27VSJordan Patric · Atlanta, GAN27XAHansman Robert J · Cambridge, MAN27ZLRegistration Pending · Alpine, NJRegistration pendingN321ERRegistration Pending · Richfield Springs, NYRegistration pendingN337DDOlson Daniel E · Jamestown, NYN360GHRegistration Pending · Truckee, CARegistration pendingN45AWWiederkehr Anthony C · Arlington, WAN45EMGlaab Louis J · Hampton, VA
Back to AD 2000-04-26