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.
N73266Macair Aviation LLC · Xenia, OHN73267Schutze Eric D · Ojai, CAN7326EMountain South Aviation LLC · Telford, TNN7326MCammack Steve · Round Rock, TXN7326SState Of Alaska Department Of Public Safety · Anchorage, AKN7327ACordova Coast Inc · King Salmon, AKN7327ELarsen James M · Santa Rosa, CAN7327KCooper Jerry A · Kennewick, WAN7327TBanister James M · Florence, MTN7327XAreopagita Ronnel · Linden, NJN73289Correggio James · Shapleigh, MEN7328AToribio LLC · San Antonio, TXN7328GShort Larry D DBA · Allen, KYN7328NPersonal Fliers Inc · Sterling Heights, MIN7328SVersa Wings LLC · Port Saint Lucie, FLN7328TPickett Griffith Randall · Kansas City, MON73293Shawano Flying Service Inc · Shawano, WIN73294G And G Maintenance Corp · Miami, FLN73295Whitten Chris D · Townville, SCN73296Han Farms Inc · Inverness, MTN73298Castelan Luis E · Irving, TXN7329ASargent Evan · Camas, WAN7329GFive Guys Aviation LLC · Pendleton, SCN7329NRegent Trust Corp Trustee · Wichita, KSN7329QBooker Merle D · Connell, WAN7329SMoncourtois Mark T · Annandale, NJN732ADDavis Billy E · Castlewood, SDN732AQGold Star Air · Portland, MEN732AVRomberg Wayne Dennis · Forked River, NJN732AXAnimal Hospital Of Fayetteville Pa · Fayetteville, NCN732BASparks Steve · Hamilton, OHN732BBBishop Thomas W · Decatur, TXN732BHSeven Eagles Aviation Lc · Gainesville, FLN732BKJones Mark A · Johnson City, TXN732BYMartin James Dwight · Lancaster, PAN732CBAire Flight Systems Inc · Midwest City, OKN732CHRegistration Pending · Athens, TNRegistration pendingN732CPCivil Air Patrol · Maxwell Afb, ALN732CRGlobal Energy Werks LLC · Ely, MNN732CXEvans Terry W · Corning, IAN732DKMckay Donald E · White City, ORN732DLN732dl LLC · Driftwood, TXN732DMFlying Knights LLC · Farmington, NMN732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTN732DWKowalczyk Ryan · Boise, IDN732DZBbak Mik LLC · Ontario, ORN732ECPompa Oliver · Tucson, AZN732EEK6 Flying LLC · Murtaugh, IDN732ELAndiamo Aviation LLC · Georgetown, TXN732EPPorebski L P Jr · Odessa, FL
Back to AD 79-10-14 R1