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.
N9550BMccall Freddie W · Brewton, ALN9550GCopper Skies Aviation LLC · Mesa, AZN9550QDecatur Aero Club Inc · Decatur, ILN9550SBald Eagle Enterprises Inc · Nashville, TNN9551BLopes Gaston A · Dallas, TXN9551WBcbc Aero Services LLC · Dover, DEN95521Martin Aviation LLC · Kalispell, MTN95528Welch Clare A · Longboat Key, FLN9552AAmeriflyers Of Texas Inc · Addison, TXN9552GJesse Shipman Farms LLC · Honey Grove, TXN9552HZulu Aircraft Leasing LLC · Grants Pass, ORN9552RCauv LLC · Cincinnati, OHN9552VRico Aviation Services Inc · Miami, FLN9553ATitusville Aero Club Inc · Titusville, PAN9553SHunters Adventures LLC · Kennesaw, GAN9553XMccarthy Sean P · Jacksonville Beach, FLN95540Gracejet Aviation LLC · Brownsboro, TXN95541Pershing Air LLC · Sheridan, WYN95544Keller Lucas J · Vale, ORN9554ABagley James L · Pampa, TXN9554GMorse Donald · Priest Lake, IDN9554VCavu LLC · Fort Collins, CON9555GMccormick Eugene C · Tyler, ALN9555HWilkinson William · Anchorage, AKN9555XWalker Scott · Mammoth Lakes, CAN9556JS & D Spraying Service Inc · Panhandle, TXN9556VMiles James D · Memphis, TNN9556ZIsland Aircraft LLC · Anchorage, AKN9557BGibson Robert B · Los Alamos, NMN9557PHendrix Steven · Bakersfield, CAN9557VSkyhawk 57v Inc · Pittsburgh, PAN9557XCivil Air Patrol Inc · Maxwell Afb, ALN9558BGrap Jeffrey G · Statham, GAN9558TWatson Stephen C · Flemingsburg, KYN9558XWagner Larry D · Raleigh, NCN9559AGrace'S Wings LLC · Crystal Lake, ILFirst renewal noticeN9559DChristiansen Aviation LLC · Wilmington, DEN9559SElizabeth Dloda LLC · Hilton Head Island, SCN9559VOcm Aviation LLC · Buckeye, AZN9559XSkid Kids Aircraft Holding LLC · Grand Junction, CON955ACNaples Air Center Inc · Naples, FLN955BCWilson Douglas S · Imperial, NEN955CCN955cc LLC · Estero, FLN955CPCivil Air Patrol · Maxwell Afb, ALN955JAAero Equities LLC · Ventura, CAN955LCSewell Michael D DBA · Russellville, ALN955LSSomd Seaplanes LLC · Lexington Park, MDN955MSSanz Mark L · Missoula, MTN955PTCappe Investment Group LLC · Homestead, FLN955RSDuck Troy · Kannapolis, NC
Back to AD 79-10-14 R1