AD 74-18-13
Registered aircraft · 1,642
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:74-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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.
N860DMC & C Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeN8614NFarmers Bank Of Northern Missouri Na · Unionville, MON8621NMcdonald Timothy Shane · Saint Jacob, ILN8622NPapp Adam P · Raleigh, NCN8625NJanicke Clayton R · Bird City, KSN8626NCf Aviation LLC · Wellington, FLN8629NN8629n Inc · Ooltewah, TNN8630NLowe Alexander · Wauwatosa, WIN8631NOwen Toy C · Anchorage, AKN8634NWright David P Jr · Chandler, AZN8652NDavis Rick J · Los Lunas, NMN8656NN8656n LLC · Weston, NEN8658NOne Way Aviation LLC · Warner Robins, GAN8660NRobbins Jode A · Cameron, WIFirst renewal noticeN8661NLyman Jared C · Plymouth, CAN8666NTlc Aviation Ltd · Virginia Beach, VAN8667NSky High Flyers Flying Club Inc · Holbrook, NYN8669NBauer Roger · Saint Germain, WIN8673NFuhrman Scott R · Meridian, IDN8674CLaney Ashley · Jacksonville, FLN8674NKesselring Aircraft Leasing Corp · Bayard, IAN8676NBerger Kevin · Peachtree City, GAN8677NCosgrove William E · Salt Lake City, UTN8678NGranberry Walter E · Lubbock, TXN8682NSt Augustine Bluewater LLC · Saint Augustine, FLN8683NAirwide LLC · Deerwood, MNN8684NTmi Aviation LLC · North Myrtle Beach, SCN8685NCummings Stephen · Fenton, MON8686NOgden Mark Thomas · Boerne, TXN8687NOpen Air LLC · Glendale, AZN8688NAerosky LLC · Holly Springs, NCN8689ESeufert Steven W · Chelmsford, MAN8689NHewitt Donald R · Califon, NJN8694NCitadelle Holdings LLC · Palmetto Bay, FLN8698NUnder Bridge LLC · Wilmington, DEN8699NHolding Short LLC · Travelers Rest, SCN86AJMullins Mark C · Riverside, CAN86CAInternational Air Services Inc Trustee · Carson City, NVN8712EBec Industries LLC · Toms River, NJN873ARRincon Jose Antonio · Santa Maria, CAN8768KRegistered aircraftN876EEEwing Robert A · Cedar Grove, NJN877DSEvans Ashley E · Elizabeth, CON878MJJackson Air LLC · Paragould, ARN8791EKl&Z Farms LLC · Littleton, NCN8797BDalton Robert Frank · Jackson, CAN8797CMeadowlake Airpark LLC · Lenoir City, TNN888TMFive G Aviation LLC · Nampa, IDN8905NHigh Noon Leasing LLC · Anchorage, AKN8907NCrain Roan · Cookeville, TN
Back to AD 74-18-13