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.
N955SPBarto Jerrel C · Kula, HIN95602King Douglas W · Bend, ORN9560BAltair Aircraft LLC · Gainesville, FLN9560SMoore Justin W · Hollywood Park, TXN9560TStern Harvey W · Middletown, NYN9560VRegistration Pending · Big Spring, TXRegistration pendingN9560WGeneral Aviation LLC · Henderson, NVN9560XSammons Richard Allen · Glen Arm, MDN9561GFlying D Aero LLC · Colorado City, TXN9561VAbove And Beyond Aviation LLC · Austin, TXN9561XAirxn LLC · Williams, AZN9562BCharleston Flying Club LLC · Charleston, SCN9562HL & W Aircraft Investments LLC · Homestead, FLN9562PAvolant Aviation LLC · Mooresville, NCN9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORN9562THiggs Jared E · New Boston, TXN9562VWinged Winds LLC · Douglassville, PAN9562XMclenaghan Alvin N · Phoenix, AZN95631Tree Top Partners LLC · Berea, KYN9563AChristiansen Aviation LLC · Wilmington, DEN9563GLitzen Guide Service · Kenai, AKN9563HHartman Thomas J Trustee · Anchorage, AKN9563XGraham Raymond S · Citra, FLN95649Hawker Aviation LLC · Lewes, DEN9564HLafleur Laurence J · Natick, MAN9564TAlvarado Ruben Jr · Brownsville, TXN95650Jnl Leasing LLC · Basalt, CON95659Uccellino Inc · Roslyn Heights, NYN9565MBitterroot Ventures LLC · Show Low, AZN9565VHijazi Sakher Samir · San Clemente, CAN9565XBerkbiegler Allen L · Lonedell, MON95661Godfrey Turhan L · Lewis Center, OHN9566BQualitair LLC · MichelstadtN9566HGarcia Mario · Yuma, AZN9566LNorth Sound Aviation · Sedro Woolley, WAN9566VS D Enterprises Ltd · Brookhaven, NYN95677Steils Building Renovation And Management Inc · Lino Lakes, MNN95678Jpr Aviation LLC · Hillsdale, INN9567AProflight 1 Inc · Midland, NCN9567HCurley Mark L · Alamosa, CON9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationN95682Longview Research And Development Inc · Chetek, WIN95686Shutt Terence M · Goleta, CAN9568GTakai Hiroyasu · San Jose, CAN9568JJeep Kenneth M · Wadsworth, ILN9568LD & S Aviation LLC · Spring, TXN9568VAnderson Zachery D · Bigfork, MTN95696Cobb Brent D · Eden Prairie, MNN9569HOsborn Larry R · Summerville, SCN9569TThomas Richard E · Lafayette, TN
Back to AD 79-10-14 R1