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.
N52417Eaton Roger C DBA · Vernon, NYN5241DSorbi Aviation Inc · El Cajon, CAN5241EBaldeo Kessho I · Bay Shore, NYN5241FUnited States Air Force Owner · Apo, APN5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN52420Isaacs John S · Fruitland Park, FLN52422Stevens Michael C · Kaysville, UTN52426Smtm Holdings Inc · Wilmington, DEN5242DR&R Aero Services LLC · Eden Prairie, MNN5242EWeeks Charles C · Setauket, NYN5242QShimata Kenneth S · Honolulu, HIN5242RProctor Daniel L · Elkton, VAN52430Beaudikofer Eric · El Centro, CAN52431Lippian James Michael · New Boston, TXN52432Aftcloud Inc · Ontario, CAN52436Angel Aviation Inc · Peoria, AZN52438Rick Aviation Inc · Newport News, VAN5243DStoltzfus Sandra · Kidron, OHN5243ECalifornia Professional Flyers Inc · Murrieta, CAN5243RDraco Flight School Inc · Chino, CAN52440Hap'S Air Inc · Ames, IAN52441Christiansen Aviation LLC · Wilmington, DEN52443182-52443 LLC · Queen Creek, AZN52447Msc Services Inc · Hugo, OKN52448Haman Peter A · Douglas, WYN5244DMalnarick Kyce S · Anchorage, AKN5244EOpal Aviation LLC · Athens, GAN5244NCongressional Flying Club Inc · Gaithersburg, MDN5244RClauson Ed P · Charlestown, RIN5244URoberts Todd · Friday Harbor, WAN5244VKnucklehead Aviation LLC · Cedar City, UTN5244ZRobinson Levi B · Anchorage, AKN52450Vandelay Investment Group LLC · Northbrook, ILN52454Clemens Kayleen · Arnold, CAN52458Eightball Air LLC · Spokane, WAN52459Noonan Joseph E Jr · Northport, MEN5245KPerun Av LLC · Cliffside Park, NJN5245VMarianas Air Transfer Inc · Saipan, MPN5245XPlane Fixer LLC · Ball Ground, GAN52465Clutter Mark R · Spencer, OHN52466Stanley Louis J · Onaway, MIN5246UMize Helicipter LLC · Edmond, OKN52473American Patrols Inc · Midland, TXN52476Good Guys Flying Club LLC · Colorado Springs, CON5247QCavu Pilot LLC · Powell, TNN5247RHarbour Aviation LLC · Weatherford, TXN52483Walsh Air Enterprises · Sugar Land, TXN52487Johnson Thomas W · Westminster, MDN52489Cardinal Club Llp · Fargo, NDN5248EColorado Skywagon LLC · Kiowa, CO
Back to AD 79-10-14 R1