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.
N799HPBristol Bay Air Service Inc · Dillingham, AKN799JLackemann Thomas E · Sayville, NYN799KTAdams Aviation Services Inc Trustee · Wilmington, DEN799PCRegistration Pending · Colorado Springs, CORegistration pendingN799THeinimann Markus B · Latrobe, PAN799THWingsleasing LLC · Wichita, KSN79AGarg Christopher D · Shoreline, WAN79AWRoberson James V · Coolidge, AZN79BBRegistration Pending · Wilmington, DERegistration pendingN79BVBethurem Conrad D · Sheridan, WYN79CNew World Wind Ltd · Quartzsite, AZN79CDMcvay E Howard Jr · Riverside, RIN79CHPala Angel E · Taos, NMN79DLWilsco Robert L · Arlington, WAN79FFamuliner James N · Carrollton, MON79FFFf22 LLC · Scottsdale, AZN79GSUavionix Corp · Bigfork, MTN79JPErickson James · Wasilla, AKN79LMMoore Chase · Bozeman, MTN79MPMissouri State Highway Patrol · Jefferson City, MON79NHSchmidt Aviation Inc · Boring, ORN79PCRuskin Keith Jonathan · Chapel Hill, NCN79PKBotttomley William K · White Salmon, WAN79RCBach II LLC · Lafayette, LAN79SLCade David M · Asheville, NCN79TCBear Cat Air LLC · Gun Barrel City, TXN79THHudson Thomas · Bessemer, ALN79TRWallace Ronald J · Santa Teresa, NMN79VK3g'S Aviation LLC · St Simons Island, GAN79WGSmith Ryan · Leawood, KSN79WWWindward Aviation Inc · Puunene, HIN7AIntabyte LLC · Portland, ORN7AABolyard Norma · O Brien, FLN7AFN7af LLC · Ronkonkoma, NYN7ALFlying Fortress Of Swfl LLC · Fort Myers, FLN7AMGalluzzi Michael C · Edgewater, FLN7CEGerhardstein Gregory V · Friday Harbor, WAN7CTDenney Michael J · South Lake Tahoe, CAN7CWDalton Christopher J · Vlg Of Lakewd, ILN7CXChapman Daniel W · Soldotna, AKN7DGElizabeth City State University · Elizabeth City, NCN7DLWubben Robert · Waupaca, WIN7FKRed Rock Aviation LLC · Las Vegas, NVN7HRCessna 182p N7hr LLC · Homer, AKN7JZR & R Vehicles LLC · Davie, FLN7LBLiberty University Aviation Dept · Lynchburg, VAN7LPFirth Leonard F · Navasota, TXN7LSChabrian Peggy · Port Orange, FLN7LTRobertson Cameron Lee · Las Vegas, NVN7MLPuchner Christopher C · Ester, AK
Back to AD 79-10-14 R1