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.
N8083SKoenig William J · Benedict, MDN80841Sparta 140 Club Inc · Grand Rapids, MIN80842Augusta Aviation Inc · Augusta, GAN80847Evergreen Flying Club Inc · Medina, WAN8084ARegistration Pending · Madison, NHRegistration pendingN8084BN8084b LLC · Fort Worth, TXN8084FAustin Michael S · Utica, KYN8084SHunter Robert M · Rawlins, WYN8084TKnight Doyle D · Loon Lake, WAN8084XSnyder Paul G · Lincoln, NEN80855Bowe Joseph E DBA · Chippewa Falls, WIN8085BHowell Rebecca Elizabeth · Elgin, TXN8085EMcdonald Douglas A · Falls Church, VAN8085LDowns Warren · Dillingham, AKN8085SSchulz Michael L · Norfolk, NEN80864Kessler Garry A · Lansing, WVN80865Green Rick A · Hudson, IAN80866Preston Richard K Trustee · Albuquerque, NMN80868Paradis Paul A · Bar Harbor, MEN8086ANievin Garrett P · Ashburn, VAN8086TRains David O · El Paso, TXN8086VSchmitt Rudy · Brookshire, TXN8086XPaumen Kurt J · Ramsey, MNN80870Robben William J · Pampa, TXN80871Monnin Aviation LLC · Amherst, NYN80872Yakima 872 Flying Club · Yakima, WAN80874Jls Aviation LLC · Fredericksburg, VAN8087ARichards Vincent C · Deland, FLN8087FWarbington Michael L · Enid, OKN8087LBawden Scott L · Saint George, UTN8087SBridges Jeffrey · Allen, TXN8087XMagers William L · Nampa, IDN80884Rein W Clark · Ottawa, KSN8088LMarciano Raymond P · Cleveland, OHN8088SRutherford Thom J · Birchwood, WIN8088XSky 66 Aero LLC · Talala, OKN80896Dsr-Cherokee 180 LLC · Dallas, TXN80899Pedersen Herbert N · Willard, UTFirst renewal noticeN8089ESkywarrior Flight Training Inc · Pensacola, FLN8089FFlying A Aviation LLC · Archer City, TXN8089GWellman Steven R Trustee · Englewood, FLN8089SBleier Rachel · Grayslake, ILN8089TGonzaez Richard · Granbury, TXN808BCMahanawai Lele LLC · Honolulu, HIN808BPChemtech-Engineering Inc · Racine, WIN808DWHall Danny J · Torrington, CTN808ESStaples Safari Ministries Outreach · Clayton, WAN808FSBradley Supply Company LLC · Mesquite, NVN808KSDucks Are Free LLC · Salina, KSN808PEBarbers Point Flight School LLC · Kapolei, HI
Back to AD 79-10-14 R1