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.
N61967Pereira Jailton · Elizabeth, NJN61969Registered aircraftN6196DJeff Air Pilot Services LLC · Shelbyville, INN6196EHiggins Brian D · Flower Mound, TXN6196GFirst Air Service LLC · Show Low, AZN6196NMccarthy Sean P · Siloam Springs, ARN6196PChristiansen Aviation LLC · Wilmington, DEN61971Bayport Alumni Recreational Flyers LLC · Shirley, NYN61972Smtm Holdings Inc · Wilmington, DEN61973School Data Solutions Inc · Spokane, WAN61974Proclaim Aviation Ministries · Worthington, MNN61975Fern Sky LLC · Monroe Township, NJN61977Rdr Racing Inc · Latta, SCN61979Maciak Michael · Center Conway, NHN6197BBarber James M · Oklahoma City, OKN6197EAl-Bert Consulting Inc · Lakeland, FLN6197ZClermont Management Services Inc · Marietta, GAN61982Airwatch LLC · Santa Rosa, CAN61985Wiltshire Henry C Jr · Plymouth, MAN6198BModel A Mlc LLC · Seattle, WAN6198FFox Aviation LLC · Glencoe, ALN6198KPoland Charles Fallon Pennock · Humacao, PRN6198NChristiansen Aviation LLC · Wilmington, DEN6198TLim Ronald · Redding, CAN61990Bauman William O · Abbeville, SCN61991Keime Parker · Show Low, AZN61994Mohawk Flying Club Inc · Ada, MIN61999Aircraft Structural Repair Inc · Hamilton, MTN6199FAcara Aviation LLC · Portage, MIN6199GPerez Joseph F · Hollywood, FLN6199RSchutte Ernest C W · Abita Springs, LAN619CHOrion Works Limited · Denali Park, AKN619CTCoast Flight Training And Management Inc · San Diego, CAN619DT6 Dt Flyers LLC · Corpus Christi, TXN619EREmbry-Riddle Aeronautical University · Prescott, AZN619SPJet Air Inc · Iowa City, IAN619THAce Aviators LLC · Logan, UTN619VMHalberg Barri R · Yacolt, WAN619WCHansford Mark T · Blue Ridge, GAN619ZFlying Dentist LLC · Flagstaff, AZN61ABj Aviation LLC · Beaver Meadows, PAN61BQEle Motorsports LLC · Dover, DEN61CEBarr Air Patrol LLC · Mesquite, TXN61CMSmith Leslie E · Cumberland, KYN61DWZandri Stefano A · Ridgefield, CTN61ECBald Mountain LLC · Dedham, MEN61ELMartinez Del Sobral Luisa Del Carmen Romero · Justin, TXN61GAGlidewell Aviation Inc · Parkland, FLN61HSCebuhar Phillip Joseph · Inola, OKN61JRSawyer Mark S · Simi Valley, CA
Back to AD 79-10-14 R1