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.
N52751Weinstein Mark H · Carrollton, GAN52753Omark Aviation LLC · Naples, FLN52754Torgerson'S LLC · Ethridge, MTN52757Brady Aviation Ltd Co · Friendswood, TXN52758Luse David C · Newalla, OKN5275DWorrell Sharyl L · Anchorage, AKN5275EPasiewicz Shannon M · Anchorage, AKN5275QSkyfarmer LLC · Culleoka, TNN5275S75s Leasing LLC · Greenwood Village, CON5275VViatrans LLC · Pryor, OKN5275WMustang Sally Aviation LLC · Camden, SCN52761Reb Baron Aviation LLC · Riverdale, CAN52764Skylane LLC · Williamsburg, VAN52765Benson Daniel P · Lake Placid, FLN52767Loudy William E · Rigby, IDN5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedN5276ESchmutz George L · Atascadero, CAN5276PBellers Aviation Inc · Fremont, CAN5276QCarter Nolon D · Kirksville, MON5276VSky West Aviation Inc Trustee · Albuquerque, NMN52775Pa-18 LLC · Hood River, ORN5277EJefredo Corp · Zephyrhills, FLN5277JYr-Aircraft Leasing LLC · Bethel, AKN5277PBennett Glenn D · Kingwood, TXN5277VLechner Gary D · Woodstock, ILN52781Mckendry Martin · Carmel Valley, CAN52783Valdes Alfonso · El Paso, TXN52786Moore Roger · Jonesboro, ARN52789Alameda Aero Club · Alameda, CAN5278DN5278d LLC · Dover, DEN5278ESeasholtz John O · Fresno, CAN5278QRegistration Pending · Madison, MSRegistration pending, canceledN5278RHussain Mahmoud Taimour Said · Miami, FLN5278VZubrod John W · Ebony, VAN52791Gibson James W · San Antonio, TXN52792Ball Richard W · Ridgefield, CTN52794Hawk Flyer 794 LLC · San Bruno, CAN52795Key Lime Consultants LLC · Belleview, FLN52797Supinie Andy · Wichita, KSN5279DDay Aviation Inc · Wilmington, DEN5279GArnold Jason Mcree · Watkinsville, GAN527AAlpha Romeo Aviation LLC · Phoenix, AZN527ANDaisy Aviation LLC · Beavercreek, OHN527BMMarc Inc · Bolton, MSN527CAIsaacson Scott D · San Diego, CAN527DSSkyhawk Leasing LLC · Greenfield, INN527NDPhoenix East Aviation LLC · Daytona Beach, FLN527ZMTextron Aviation Inc · Wichita, KSN52800Jackson Royalties Inc · Brandon, MSN52802Gune Abhijit P · Dublin, CA
Back to AD 79-10-14 R1