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.
N9439URautiola Patricia H · Rosemount, MNN9439XBallard Richard D · Juneau, AKN9439YR C S Drilling Company Inc · West Lake Hills, TXN943AHHaley Keith · Tonawanda, NYN943CPCivil Air Patrol · Maxwell Afb, ALN943KSStark James E Trustee · Sun City, AZN943SPLittle Airplanes LLC · Aurora, ORN943THSpirit Aviation Management Services Inc · Thomson, GAN94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9440BRamos Daniel J · Pueblo, CON9440USmith Peter I Trustee · Ocala, FLN9440XMountain Flyers Inc · Asheville, NCN9441AKing Beth A · Louisville, KYN9441BSmith Mickey D · Tyler, TXN9441MGuemes Aloft LLC · Portland, ORN9441TDevil Dusters Inc · Artesia, NMN9441ULewis Paul A · Spring, TXN9441XMurphy Peter D · Santa Fe, NMN9441ZTjb Capital LLC · Nashville, TNN9442Winger Aviation LLC · Palatine, ILN9443CRvest Management LLC · Boulder City, NVN9443HAllport Bruce E · North Hollywood, CAN9443LTdz Aircraft Holdings LLC · Dover, DEN9444BWallitner Aviation Inc · Renton, WAN9444HPrestige Worldwide Aerospace LLC · Panama City, FLN9444MTriple Four Mike LLC · Sand Springs, OKN9444UB2w Corporation · Winona, MNN9445AAlsup Alan D · Gainesville, TXN9445CSchaller Lee W · New Athens, ILN9445DTriple Fes LLC · San Antonio, TXN9445HBrown Max K · Cushing, OKN9445MSky Masters Aviation Inc · Laguna Hills, CAN9445THale Tom · Browns Valley, CAN94461Daytona Aircraft Leasing LLC · Daytona Beach, FLN9446CAlaskan Luxury Cruises LLC · Willow, AKN9446GStringfellow Regan M · Boerne, TXN9446NSkywagon LLC · Goochland, VAN9446UTepper Jesse J · New York, NYN9447HLang Julia A · Greensburg, PAN9447LAirplane And Drone Flight Instruction LLC · Orlando, FLN9447MWings Aircraft LLC · New Richmond, WIN9447XKaminski Thomas E · Green Bay, WIN9448AOlson Ben A · Gig Harbor, WAN9448CAero Marine Inc · Westland, MIN9448MSoto Eduard D Trustee · Somers, MTN9448UValley View Farming Inc · Halsey, ORFirst renewal noticeN9448ZAmeriflyers Of Florida LLC · Addison, TXN9449ASiglin Sybil Joann · Pleasanton, CAN9449BLeaders Bob O · Clear Lake, MNN9449XBelk Pritchard Properties LLC · Broken Arrow, OK
Back to AD 79-10-14 R1