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.
N3797WCarter Thomas Shane · Pinetop, AZN37MVMonreal Michael · North Barrington, ILN3800WJdj Transport LLC · Wilmington, DEN3801WSale Reported · Silver City, IASale reportedN3803WDelp Ryan K · Southbury, CTN3807WFeller Gerald A · Long Beach, CAN3808WDodson International Parts Inc · Rantoul, KSN3809WFair Skies Aviation LLC · Cincinnati, OHN3811WMartin Gerard A · Boston, KYN3812WTuned Up Services Inc · Waldo, FLN3813WTaylor Bruce W · Stroudsburg, PAN3814WN3814w LLC · Maumee, OHN3815WCk Aviation LLC · Milledgeville, GAN3818WHeadwinds Maintenance Inc · Fort Pierce, FLN38226Martinex Aviation LLC · Wentzville, MON3823WCherokee N3823w LLC · Huntsville, ALFirst renewal noticeN3824WTeel Brian P · Hooper, UTN3825WKaizen Companies Inc · Boise, IDN3826WMiller Heather J · Dupo, ILN38276N38276 LLC · Las Vegas, NVN382FSSmith Michael L · Smyrna, SCN3830WKris Noone Air LLC · Wilmington, DEN38331Johnston Craig J · Ocean City, NJN3833WKurz Sean H · Blairsville, PAN3836WOconnell Richard M · Dothan, ALN3841WHirschler Steven · Big Bear Lake, CAN3842WAnderson David A · Omaha, NEN3843WStrong Jason · Agency, MON3852WHaymond David G · Sandy, UTN3854WValiair Lc Trustee · Casper, WYN3855WRcr Aviation LLC · Punta Gorda, FLN3856WBarr Barry · Memphis, TNN3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeN3860WBrasfield Jason · Bonnerdale, ARN3861WMendez Fidel Serrano · San Sebastian, PRN3865WWestenberger David L · Indianapolis, INN3866WN3866w LLC · Broken Arrow, OKN38677Bass Michael L · Mount Olive, NCN3867WN3867w LLC · Clemson, SCN3873WBrault David M · Lake Stevens, WAN3874WSplit Oak Contracting Inc · Williamson, GAN3876WSteele Kyle Z · Acworth, GAN3879WSale Reported · Texarkana, TXSale reportedN3880WSpecialized Communications · Smithsburg, MDN3881WKincaid Bruce W · Garland, TXN38854Schmidt Ryan A · Medinah, ILFirst renewal noticeN3886MBravo Foxtrot Partners LLC · Knoxville, TNN388TWeimer David J · Knightstown, INN3890WRobinson Mark A · Carson City, NVN3894WElite Fleet Jacksonville LLC · Jacksonville, FL
Back to AD 74-18-13