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.
N9966XFickus Timothy R · North Pole, AKN9967NSawtooth Aviation LLC · Hovland, MNN9967RBravan Aviation · Fort Lauderdale, FLN9968APickett Steven M · Odenville, ALN9968EReeder Joseph · Northfield, MNN9968FSoutheast Aircraft Leasing LLC · Jacksonville, FLN9968GPetecraft Aviation Services Inc · Plains, GAN9968LMw Flying LLC · Sanford, NCN9968NBuhannic Patrick A · Shepherdstown, WVN9968TMontague Robert · Kilmichael, MSN9968VCynthiana Flying Group Corp · Cynthiana, KYN9968XEagley Ronald A · Anchorage, AKN99697Sky High Leasing Services LLC · Lakeland, FLN9969ARegistration Pending · Frostproof, FLRegistration pendingN9969BGreenwalt Bert · Jonesboro, ARN9969THatch Industries LLC · Snowflake, AZN9969VCosta William · Farmington Hills, MIN996AKSierra Sky Aviation LLC · Kalispell, MTN996CAClassic Aircraft Investments LLC · Tega Cay, SCN996CPCivil Air Patrol Inc · Maxwell Afb, ALN996MWWiehl In The Sky LLC · Mount Juliet, TNN996RAN996ra LLC · Palm City, FLN996SAEp Aero LLC · Parkton, MDN996TALi LLC · Seattle, WAN996WWPea-Wayman Flight LLC · Daytona Beach, FLN99700Lee Rich · Carlsbad, CAN99709Long Island Aviators LLC · Seaford, NYN9970AKingsley Kiman J · Miller, MON9970VSpalding Flying Club LLC · Griffin, GAN9970ZHartland Aviation LLC · Hartland, MIN99712Nesher Aviation II LLC · Jacksonville, FLN99715N99715 LLC · Wheeling, ILN9971AZilinsky Robert F · Willowbrook, ILN9971EGuerrero-Reyes Fernando G · Princeton, NJN9971NCranford Billy J · Wasilla, AKN9971TGuardalabene Anthony E · Lake Havasu City, AZN9971VWalters Aaron R · Estes Park, CON99725Holladay Aviation LLC · Jacksonville, FLN9972ARegistration Pending · Seattle, WARegistration pendingN9972NChandler E H Jr · Ozona, TXN9972VMotley Charlotte J · Summerdale, ALN9973AGuillebeau Instruction Inc · Sherwood, ARN9973BMajor Air LLC · Charleston, SCN9973FMayer Larry A · Billings, MTN99744Christiansen Aviation LLC · Wilmington, DEN9974BAppalachian Aviation LLC · Harrisonburg, VAN9974ERajdl Alan · Deer River, MNN9974MAllmen David B · Valley Center, CAN99750Kool Wings Leasing LLC · Indianapolis, INN99759Civil Air Patrol · Maxwell Afb, AL
Back to AD 79-10-14 R1