AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N8346LJones Mark B · Angleton, TXN8346XMessinger Donald C · Wasilla, AKN8346ZHerrick William L · Howell, MIN8347GKeyes Mitchell R · Cornelius, NCN8347LSchye Ted E · Billings, MTN8347SShaffer Dyke T · Santa Rosa, CAN8347ULeupp Matthew C · Canal Winchester, OHN8348AKelly David M · Issaquah, WAN8348BSogg Steven L · Auburn, WAN8348LPrice William B · Lamar, SCN8348MWings Over Texas Holdings LLC · Denton, TXN8349ASudtell Chad S · Wasilla, AKN8349EArment C Randall · Valentine, NEN8349MMarker Nathan E · Amherst, OHN8349TStefan Terrence J · Dodge City, KSN8349UMassey Jay C · Mineral Wells, TXN8349XRoberts Thomas Randy · Amarillo, TXN834CPCivil Air Patrol · Maxwell Afb, ALN834DAb Prop Plane II LLC · Metairie, LAN834KXHillsboro Aero Academy LLC · Hillsboro, ORN834ZGroshel Joseph C · State College, PAN8350APhillabaum Stephen D · Deer Park, WAN8350BTatum Travis · Gatesville, TXN8350JSustarich Stephen M · Ketchikan, AKN8350SRegistration Pending · Wheatland, CARegistration pendingN8350UColeman Timothy J · Cornwall On Hudson, NYN8350XLee Daryl P · Poplarville, MSN8351JRkd Aviation Services Inc · Dallas, TXN8351LPlane Junkies LLC · Dover, DEN8351MWheaton 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, NCN8352LFielding David · Scarborough, MEN8352MOak Ridge Flyers Inc · Oak Ridge, TNN8352QUnited Indian Missions DBA · Tucson, AZN8352SMacwilliamson Roger · Hollister, CAN8352UVirani Shamshuddin · Fayetteville, GAN8352XSchmid William J · Anchorage, AKN8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeN8353GHove Jeffrey P · Saint Paul, MNN8353XAcme Racing LLC · Overland Park, KSN8353ZMccoy Jesse Jacob · Cabot, ARN8354BTri Flight LLC · Cottonwood, MNN8354LEast Texas Imperial Petroleum LLC · Flint, TXN8354SNorthrop Kimberlei A · Spokane, WAN8354UErvin Jerome · Lometa, TX
Back to AD 79-10-14 R1