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.
N6833AChapter 163 Flying Club · Las Vegas, NVN6834FLecompte Kevin J · Lancaster, MAN6834GRoberts Edwin G · Lake Wales, FLN6835ABaratka Darin W · Phillips, WIN6835HIowa Lakes Community College · Estherville, IAN6835MMgadi LLC · Trenton, MIN6836ARiner Mark G · Bartlesville, OKN6836FFoley Anthony · Savannah, GAN6836GRegistration Pending · Highland, UTRegistration pendingN6836XNelson John D · Sonora, CAN6837ANorth Nathan A · Damascus, MDN6837FSkyberjet LLC · Allen, TXN6838EBognar Jeffrey L · Kinnelon, NJN6839MKulton Jon T · Somonauk, ILN6839XCripe Rodney J · Middlebury, INN683CPCivil Air Patrol · Maxwell Afb, ALN683HBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN683HDFord Dwight M · Gig Harbor, WAN683JWLotela Partners LLC · Avon Park, FLN683SPNovember 243 Bravo Mike LLC · Castle Rock, CON6840AMcnaught Scott S · Winlock, WAN6840FBushre David · Janesville, WIN6840GMiller Robert L · Tecumseh, MIN6840MFlying R Aviation LLC · Trenton, MON6840XDesertshot Inc · El Paso, TXN6841ASmooth Flying LLC · Barnwell, SCN6841XNelson Ricky R W · Mandan, NDN6842FRodriguez Leyla M · Bellflower, CAN6842MBognar John A · Belgrade, MTN6843ECampbell Ronald M · Upland, CAN6843FMoyers John Jason · Midlothian, VAFirst renewal noticeN6843GTracey Corp · Midland, VAN6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTN6843RArkansas Air LLC · Jackson, WYN6843XBoone Alan · Bangor, MEN6844MBarker Edward J · Claremore, OKN6845EShores Kelly W · Thayer, ILN6845FHoward Donald E II · Ponca City, OKN68460Registration Pending · Sheridan, WYRegistration pendingN6847AEwald Christopher Robert · Blanding, UTN6847DPietron Spraying Inc · Larimore, NDN6847FFranko Gregory · Grindstone, PAN6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeN6848FWhitehead Mathew S · Leesville, LAN6848MFitts Wayne T · Independence, ORN6848XHinkleman Howard R · Brownsboro, ALN6849EHofer Perry L · Doland, SDN6849FDeangelis Jarrod A · Henderson, NVN6849XReiss Alan T · Gig Harbor, WAN684CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 79-10-14 R1