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.
N9085MLee Aviation Group LLC · Fort Myers, FLN9085XCessna 182 LLC · Missoula, MTN9086ATaylor Scott G · Draper, UTN9086GWilcox Leo Morgan · Winnie, TXN9086ZCy Air LLC · Springfield, MON9087GHigh Planes LLC · Carter, MTN9087TGuminsky Michael · Toano, VAFirst renewal noticeN9087XLane James T · Theodosia, MON9088ACox-Kuss Sarah Ann · Colorado City, TXN9088XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVN9089HDavis Joseph S · Andalusia, ALN9089XSebec Aviation Services LLC · Willimantic, MEN908CPCivil Air Patrol Inc · Maxwell Afb, ALN908ENEl Aviation LLC · Alpena, MIN908EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN908FGRidgeline Assets LLC · Wilmington, DEN908HPNiessner Steven A · Golden, CON908MCL2 Leasing LLC · Orem, UTN908SCGomez Ryan Rene · Fort Worth, TXN9091HCampbell Raymond · Box Elder, SDN9091MFrisbee Dennis R · Denton, TXN9091TBeachy Daniel W · Council, IDN9092HWinemiller Stevie Dale · Swifton, ARN9092XWharton Joel E · Millsboro, DEN9093GThomas Kent · Wilsonville, ORN9094GRicks Thomas C · San Carlos, CAN9094RPetecraft Aviation Services Inc · Plains, GAN90951Simard Maurice E · Windham, CTN9095MSchramm Dale · Toledo, WAN9095XTaylor William E Trustee · Waynesville, MON9096HCallaway Mary Ann · Homedale, IDN9096MRedd Charles H Jr · Wasilla, AKN9096ZChristianen Aviation LLC · Wilmington, DEN9097AWard Daniel Wayne · Boonville, NCN9097GScharping Glenn Alan · Whitelaw, WIN9097MClark David T · Grand Rapids, MNN9097XMcmillin Charles R · Lynn, MIN9098AWestphal Keith H · Mazomanie, WIN9098X98x LLC · Caddo Mills, TXN9099GRegistration Pending · Edmond, OKRegistration pending, pending cancellationN9099XSnow Sam L · Las Cruces, NMN909CPCivil Air Patrol · Maxwell Afb, ALN909CQVan Bortel Aircraft Inc · Arlington, TXN909CSBarbers Point Flight School LLC · Kapolei, HIN909DBN909db Aviation Services LLC · Colorado Springs, CON909EDEdwards Aero Club · Edwards Afb, CAN909EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN909GBHead West Lake Operations LLC · Dubois, WYN909KSKingsky Flight Academy LLC · Lakeland, FLN909MRRipp Patrick L · Mineral Point, WI
Back to AD 79-10-14 R1