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.
N6267CTholl Robert E · Morristown, NJN6267E67 Echo LLC · Las Vegas, NVN6267FSkymaster Company LLC · Dover, DEN6267TLittleton Roy T III · Ruther Glen, VAN6267YZero Four Twelve LLC · Clovis, NMN62689Optic Air LLC · Sioux Center, IAN6268AHenshaw Jon R · Miami, FLN6268DSafety In Motion Flight Center Inc · Puyallup, WAN6268EBilton Nicholas J · Bozeman, MTN6268NCompass Rose Aviation · Derby, KSN6268RYouvan Ian · Pittsburg, KSN6268SHayes Barrett W · Siler City, NCN6268TBartkowiak Alex M · Moorhead, MNN62690Aerosim Academy Inc · Sanford, FLN62694American Patrols Inc · Midland, TXN6269ABubs Tub LLC · San Angelo, TXN6269DCongressional Flying Club Inc · Gaithersburg, MDN6269ERule Paul Crane Trustee · Wapato, WAN6269GMattingly Andrew R · New Albany, INN6269QMustang Sally Aviation LLC · Camden, SCN626AFCape Fear Pilots LLC · Bald Head Island, NCN626CBWings Over Texas Holdings LLC · Denton, TXN626DTA & F Aviation Services LLC · Collierville, TNN626EPEpic Aviation Inc · Denison, TXN626GMMike Smith Aviation International Inc · Napa, CAN626KTRustair Inc · Anchorage, AKN626LDAerofleet LLC · Oldsmar, FLN626RPWhitaker Jesse G · Anchorage, AKN626WBBorella Jay D · Bellingham, WAN6270RAbout Time Aviation · Springfield, ORN6270SHudson Kelly G · Monroe, NCN6270XLees Robert A II · Mesa, AZN6271AAshley Edward A · San Antonio, TXN6271BCountry Flyin Inc · Homestead, FLN6271ENate Abel Flying Club · Fort Worth, TXN6271GSumpter Kenneth W · Enid, OKN6271SJay Square Aircraft Inc · Hilton Head Island, SCN6271TBesteiro Aly E · Brownsville, TXN62726Xing Kong Aviation Service LLC · Atwater, CAN6272EFeauto Aviation Inc · Saint Cloud, FLN6272GDunn Michael Thomas · Arlington, VAN6273AStreufert Colton P · Boise, IDN6273EBunner Corin Anthony · Murfreesboro, TNN62740Doomac LLC DBA · Peyton, CON6274AA V T210 LLC · Palmdale, CAN6274DOracle Aviation LLC · Omaha, NEN6274EHuff Air LLC · Uvalde, TXN6274VDollbaum Robert A · Southfields, NYN6275ABrown Thomas C · Littlefield, TXN6275EValiair Limited Co Trustee · Casper, WY
Back to AD 79-10-14 R1