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.
N624CGChristy Alan · Pendleton, ORN624DRRyan Air Inc · Anchorage, AKN624ERRyan Air Inc · Anchorage, AKN624JACobb Jason L · Lancaster, OHN624MAurora Aviation LLC · Delray Beach, FLN624MTJcct Holdings LLC · Plano, TXN624WOh-Yeah LLC · Caldwell, IDN62502Hill Andrew T · Smithville, TXN62503Back Forty Flying Club Inc · Roanoke, INN6250EBox Samuel G · Stigler, OKN6250FNeeper Philip A · Fayetteville, NCN6250KOlson Terry L · Rapid City, SDN6250RJennings Frederick T · Friona, TXN6250TWinnett Tommy E · Lexington, NCN62511Dezee Matthew J · Corinth, KYN6251RCalley Adelia M · Big Lake, TXN6251TKropf Nathan L · Clarksville, ARN62527Flybarely LLC · Manitowoc, WIN62529Turner Benjamin G · Lagrangeville, NYN6252DH & H Aviation Enterprises LLC · Fairfield, OHN6252EDmac Aircraft LLC · Savannah, GAN6252GBoston Philip · Jacksonville, FLN62530M And M Club Inc · Manakin Sabot, VAN62531Lg Holdings LLC · Gretna, NEN62536Shearer Eric · Manassas, VAN6253APiper David L · Peshastin, WAN6253EReed Nathan A · Seward, NEN6253KShiffer Lyle J · Waterford, MIN6253SShroyer Rex G · Philomath, ORN62547Executive Air Taxi Corp · Bismarck, NDN6254DSeventy Seven Industries LLC · Waddell, AZN6254TNeary John · Ridgefield, NJN6254VVector Air Inc · Oklahoma City, OKN62550Jones Robert N Trustee · Palmer, AKN6255ABennett Dennis Lane Jr · Hastings, MIN6255DBowdidge Jeffrey E · Kingwood, TXN6255EHall Thomas R · Kittanning, PAN6255GHaglbohm Jeffrey S · Helena, MTN6255HRenfro Michael W · Bethel, AKN6256EParish Don P · Russells Point, OHN6256GIlmberger Stephen J · Bend, ORN6256TYork Randal G · Cullman, ALN6257ASmolinski Michael E · Withams, VAN6257DDrabek Howard E · Richmond, TXN6257SHoffmeyer Scott D · Carson City, NVN6258FNance David B · Quinton, VAN6258KGadamic LLC · Fresno, CAN6258RCache River Flyers LLC · Greeley, CON62590N62590 LLC · Wye Mills, MDN6259EN6259e LLC · Richardson, TX
Back to AD 79-10-14 R1