AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N87GVChristiansen Aviation LLC · Wilmington, DEN87GZGonzalez Jorge L · Pensacola, FLN87HFHeritage Asset Leasing LLC · Ronkonkoma, NYN87HPConnolly Andrew Leadley · Seabrook, TXN87HUGladius LLC · Nantucket, MAN87HYDuke Ray J · Texico, NMN87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILN87KCAviation 3 D Loggers LLC · Sheridan, WYN87KDKissick Kathy L · Kansas City, MON87KGCherokee From Sebring LLC · North Brunswick, NJN87KMLibbey Eric D · Solvang, CAN87LAAdams Kirk · Sanger, CAN87LJRegistration Pending · Chicago, ILRegistration pendingN87MSellers Mark · Philadelphia, PAN87MBTraining Planes LLC · Tampa, FLN87MCNorthern Blue Skies Inc · Shawano, WIN87MRReisdorfer Mark J · La Follette, TNN87MXHalbritter Shawn M · Caldwell, IDN87NMChildress Gregory F · Dallas, TXN87PCraig Stephen J Trustee · Lawrence, KSN87PDRyan Patrick W · Poway, CAN87PMMona LLC · Kalispell, MTN87PRTango Flight LLC · Thibodaux, LAN87RCTime To Fly Meseum · Burleson, TXN87RPWhitehead Glenn K · Friendswood, TXN87RVRoberts-Lethaby Jeremy P · Isanti, MNN87SDHubbert Stephen A · Newcastle, OKN87SVMontgomery Vaughn L · Washington, UTN87TKKee Franklin T · Camden, TNN87VKBurgstaller Martine S · DeurneN87WAltitude Aviation LLC · Lenoir, NCN87WAMann Ronald L · Pound Ridge, NYN87WBWild Bitch LLC · Oklahoma City, OKN87WHPerry Larry B · Montross, VAN87WJKrueger Kenneth L · Newberg, ORN87WRJohnston Donald C · Davis, CAN87XPSutherland Brian · Nolensville, TNN88002Heiderscheidt Aerial LLC · Sleepy Eye, MNN8800JRobinson Jacob · Lewistown, MTN8800WEagle LLC · Sleepy Eye, MNN8800YAlexander City Aviation Corp · Alexander City, ALN8801CBlue Chip Aviation LLC · Falling Waters, WVN8801EBlades Paul A · Newman, CAN8801MStein Bruce A · Punta Gorda, FLN8801WAfrican Research Foundation Inc · New York, NYRevoked, canceledN8801XPiercy Ronald S · Moses Lake, WAN8802Osterberg Douglas · Neenah, WIN88024Madsen Travis E · New Underwood, SDN8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledN8802JShivers James C II · Columbus, OH
Back to AD 81-18-04 R2