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.
N43998Tailwind Aviation LLC · Royersford, PAN4403TTyrrells Trails LLC · Fairbanks, AKN44087Little Island Roofing · Stuart, FLN44130Cotton John M III · Windham, NHN4417TBimini Bullet LLC · Lakeland, FLN4418TRankin Kevin K · Vandalia, OHN4425TBooth Aviation LLC · Fort Worth, TXN44295Caribbean Aviation Lc · Miami, FLN4429XPearls Pilot LLC · Jefferson City, MON44328Riddle Bruce C · Franklin, NCN44369T&B Aviation LLC · City Of Industry, CAN44494N44494 LLC · Peachtree City, GAN444LCPiper Cherokee LLC · Leesburg, VAN444NAPittman Deryl Trustee · Morgantown, INN444RMSky Taxi LLC · Fort Payne, ALN44560Niewenhuis Larry D · Grand Ledge, MIN44588N44588 LLC · Vero Beach, FLN44601Talon Aero LLC · Bowling Green, OHN44618Word Howard W Trustee · Kula, HIN44661Family Flyer Six LLC · Columbus, INN44685Sundance Air Charter LLC · Portland, ORFirst renewal noticeN4468XHalf Nuts LLC · Boiling Springs, PAN44747Goldenburg Timothy A · Ypsilanti, MIN44782Alsup Jonathan S · Tok, AKN44783Family Eye Care Center LLC · Elkins, WVN44813Olusanya Babajide A · Cherry Hill, NJN4483TWaterboy Aviation LLC · Richlandtown, PAN44851King Air Inc · Naknek, AKN4485XL & A Bennett Second Family Lp · Renton, WAN448MJWilson Darrell Gene III · Mcpherson, KSN44944Karimi Enterprises LLC · Myrtle Beach, SCN44990Fineran James V III · Towson, MDN44DZWanted Poster Owners Group LLC · York, PAN44JYAcre LLC · Abilene, KSN4508RMcmichael Timothy J · Rock Hill, SCN4513QBobcat Aviation LLC · Northfield, MNN4518TBnr Aviation LLC · Lawrenceville, GAN451JSend North · Anchorage, AKN451NKSink Craig S · Queen Creek, AZN4556FReindeer Aviation LLC · Bloomfield Hills, MIN4571TVandeventer Matthew S · Dillingham, AKN4577XFairhaven LLC · Meridian, MSN4584TLion Air LLC · South Heart, NDN4598TSikora Justin E · Jupiter, FLN4599XStar Marianas Air Inc · Saipan, MPN464SPMeshik Ground Service LLC · Port Heiden, AKN4699SStrike Allen P · Flint, MIN469BKClark John Wayne · Lexington Park, MDN46WFFoy William N · Murfreesboro, TNN4726SN4726s LLC · Wilmington, DEFirst renewal notice
Back to AD 74-18-13