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.
N3483WSale Reported · Lubbock, TXSale reportedN3485WKemp James A · Deland, FLN3486WSteele Jackie L · London, KYN3488WLiberty University School Of Aeronautics · Lynchburg, VAN348RPWright-Piros Ruth · Carlisle, IAN3492WMyers Andrew John · Wadsworth, OHN3493WVerser James A · Greers Ferry, ARN3494WHarrison Brett A · Fishers, INN3497WRobb Kirk C · Abingdon, ILN3498WKanz Robin Lea · Woodway, TXN3499WAviator Solutions LLC · Oregonia, OHN34DLAdlava LLC · Dover, OHN34JCA2b Aviation LLC · Newark, OHN34MALk Air Inc · Arlington, WAN3500WAerotyne International LLC · Prattville, ALN3501WObrien Matthew A · North Platte, NEN3502WN3502w LLC · Stephenville, TXN3510WWhite Frank M · Haines, AKN3513WFrankiewicz Victor J · Chrisman, ILN3514WBattaglia Anthony · Moosic, PAN3515WHetherington Michael R · Fairbanks, AKN3520WLyttle John W Jr · Chehalis, WAN3523WRamunni Andrew R · Medina, OHN3524WDiaz Albert · Ocean Springs, MSN3525WDavis Micihael K · Madison, GAN3526WN3526w Holding LLC · Harlem, GAN3527XSzmagala Taras G Jr · Bentleyville, OHN3534WSmittys Garage LLC · Fairmount, INN3539WPicard Joerg · Grand Rapids, MIN3541WFlying Horsemen Aviation LLC · Lyons, MIN3542WRockwall 6 LLC · Royse City, TXN3546WMelander Dan · Summit, MSN3547WNatwick Joel T · Port Alsworth, AKN3552WTwo Sixty Aviation LLC · Wilmington, NCN3553WVarn Samuel G · Thomasville, GAN3554WPerkins Chas L · Warsaw, MON3555WF&F Aviation LLC · Worthington, OHN3559CDelta Blue Line LLC · Collierville, TNN3559WSherlin Grover W · Garland, TXN355JHEmm USA Inc · Lewes, DEN3561WSchulz Beverly A · Merrill, WIN3564WWemyh Air LLC · Krum, TXN35659Steele Aviation Inc · Walnut Cove, NCN3565MSix 5 Mike LLC · Shreveport, LAN3569WFossum Richard F · Salado, TXN3571WJtw Financail Services · Norfolk, NEN3573WRay Blake · Midland, TXN3574RGarner Financial Management Inc · Franklin, TNN3576WEllison David L · Stockbridge, GAN3579WGuzman Anthony J · Hacienda Heights, CA
Back to AD 74-18-13