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.
N8398LWingsleasing LLC · Wichita, KSN8398MHale Richard W · Warminster, PAN8398SRoberts Rickey J · Kamiah, IDN8398UAdrenaline Junkies LLC · Richfield, UTN8398XCummings Thomas H · Lewistown, MTN8399BHumphrey William J · Whiteville, NCN8399LSanders George W Jr · Cloverdale, INN8399SDenver Aviation Inc · Westminster, CON8399XWard Bruce · Fowlerville, MIN839CPCivil Air Patrol · Maxwell Afb, ALN839EREmbry-Riddle Aeronautical University · Daytona Beach, FLN839KSKansas State University · Salina, KSN839SPHillsboro Aero Academy LLC · Hillsboro, ORN83AFN83af LLC · Stuart, FLN83BMShelton David B · Dallas, TXN83CBDenton William P · Dallas, TXN83EWTremarco Philip J · Anchorage, AKN83FPPhillips Tom Scott · Beach City, TXN83JHVolar Viii LLC · Edmond, OKN83JVClark Jason · Gig Harbor, WAN83JXTextron Aviation Inc · Wichita, KSN83RBBerning Ron D · Lino Lakes, MNN83SFChristiansen Aviation LLC · Wilmington, DEN83SSSomd Seaplanes LLC · Lexington Park, MDN84009Swenson Catherine A Trustee · Meadow Vista, CAN8400BEdwards R Deryl · Joplin, MON8400JBlue Wings LLC · Brecksville, OHN8400LInstant Print Signs & Designs LLC · Kalispell, MTN8400QSpillman Aviation LLC · Colorado Springs, CON8400XBurlingame Craig D · Catlett, VAN84019Snodgrass William D · Moberly, MOFirst renewal noticeN8401JKingdom Air Corps · Sutton, AKN8401LBlack Baron Air LLC · Kalispell, MTN8401QJoseph Kenneth W DBA · Canton, OHN8401UMorales Jerardo S · Belleville, ILN8401XWilkinson Bert D · Sandpoint, IDN84024Maurano Michael R · Long Island, VAN84026Smith William A Jr · Tulsa, OKN8402LVan Bortel Inc · Victor, NYN8402MBurke Shawn T · Flowery Branch, GAN8402TNalty Shannon P · Queen Creek, AZN8402UWj Rothwell Ranch Co · Hyannis, NEN8402XDominy Geary B · Flint, TXN8402ZRixford Raymond Gould · Gunnison, CON84036Wings Over Texas Holdings LLC · Denton, TXN8403QWallace Andrew M · Salt Lake City, UTN8403UAnderson Larry L · Silver City, NMN84048Kyzer Aviation Holdings LLC · Fort Mill, SCN8404JMalphurs Larry Neil · Pooler, GAN8404MMitchell Ryan G · Ventura, CA
Back to AD 79-10-14 R1