AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N83457Havener Hunter W · Chittenango, NYN8345HLauff Samuel Jr · Ocala, FLN8345MBryant William G · Kenai, AKN8345U45u Leasing LLC · Beavercreek, OHN83468Skyhawk Aero LLC · Montevideo, MNN8346GN8346g LLC · Fort Pierce, FLN8346JHodgman Robert J · Yakima, WAN8346XMessinger Donald C · Wasilla, AKN8347GKeyes Mitchell R · Cornelius, NCN8347ULeupp Matthew C · Canal Winchester, OHN8348AKelly David M · Issaquah, WAN8348BSogg Steven L · Auburn, WAN83492Kietzer Rocklyn D · Hartford, MIN8349ASudtell Chad S · Wasilla, AKN8349MMarker Nathan E · Amherst, OHN8349UMassey Jay C · Mineral Wells, TXN8349XRoberts Thomas Randy · Amarillo, TXN834SPOneal Steven Paul · Munford, TNN8350APhillabaum Stephen D · Deer Park, WAN8350BTatum Travis · Gatesville, TXN8350JSustarich Stephen M · Ketchikan, AKN8350UColeman Timothy J · Cornwall On Hudson, NYN8350XLee Daryl P · Poplarville, MSN8351HPetro Jerry R · Williamsburg, VAN8351JRkd Aviation Services Inc · Dallas, TXN8351MWheaton Eric J · Gig Harbor, WAN8351TLazic Nina · Wilmington, OHN8351URappa Colin C · Nazareth, PAN8351XSky Rangers Inc · Stockton, CAN8352AWood Jeremy D · Girdwood, AKN8352BRoark Larry W · Wheatland, INN8352JByrds Wholesale Inc · Clayton, NCN8352MOak Ridge Flyers Inc · Oak Ridge, TNN8352UVirani Shamshuddin · Fayetteville, GAN8352XSchmid William J · Anchorage, AKN83538Lee Justin W · Maud, TXN8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeN8353GHove Jeffrey P · Saint Paul, MNN8353XAcme Racing LLC · Overland Park, KSN83542Vinyard Herbert O Jr · Hammond, LAN8354BTri Flight LLC · Cottonwood, MNN8354UErvin Jerome · Lometa, TXN8354XWillow Equip LLC · Fox River Grove, ILN8355BBowen Jeffrey N · Jacksonville, NCN8355GGrant Jimmy L · Ada, OKN8355JPadilla Hector F · Mountain View, CAN8355MRcs Services LLC · California, MDFirst renewal noticeN8355TDakota Aircare Inc · Wagner, SDN8355UWilhelm Joshua Robert · Lake Havasu City, AZN8356AClinard Larry L · Escanaba, MI
Back to AD 94-05-05 R1